13 Replies Latest reply: Dec 29, 2015 7:09 AM by Bibhuti Sahoo RSS

    Hi Friends I have a sample dataset like below I want to retrieve those customers whose Promot Sales Value > 0 and Normal sales Value = 0 . How to write query in qliksense??

    Bibhuti Sahoo

      Hi Friends I have a sample dataset like below I want to retrieve those customers whose Promot SalesValue > 0 and Normal Sales Value = 0 . How to write query in qliksense??

       

       

      CustomerSellTypeSalesValue
      XG970201NORMAL0
      XE355501PROMOT1453
      XE711301NORMAL0
      XE355501NORMAL0
      XF970201PROMOT0
      XE530601NORMAL0
      XE653901NORMAL0
      XE653901PROMOT108756

       

       

      Thanks & Regards,

       

      Bibhuti