7 Replies Latest reply: Jan 15, 2014 8:09 AM by Luis Armando Molina RSS

    How to get specific value from one Straight Table?

      Hello, I've thought about it, and I need help trying to find a way to solve this problem, there must be a simple way to do it, but I'm new to qlikview.


      I have the following table:



      I would like to do something like:

      If (Select * From StraightTable Where Clasificacion = 'A') = Null Then

           //Do Something


      //Do Something


      But I don't know how to do it, What I want to do is to check if In my table there are A customers, if there are not, then the customer with the Higher "Venta Neta" would be A, then the next B, I hope you understand and can help me.


      Best regards Luis