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:

       

      Dataqlikview.JPG.jpg

      I would like to do something like:

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

           //Do Something

      Else

      //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