1 Reply Latest reply: Dec 13, 2017 7:35 AM by Sunny Talwar Branched to a new discussion. RSS

    How can add "If and" condition in pivot table in Qliksense

    vinayak lAKESHRI

      How can add "If and" condition in pivot table in Qliksense?

       

      I have two table having data for two country, Country A and B. I have loaded data in qliksense.

      I am using Formula for calculating % for each country across the field but I am able to find the output for only one country.

       

      Formula as

      1st formula-

      If (Client_type=Individual and country = 'A', (Sum(VALUES)-(value))/sum(VALUES),

      If (Client_type=Individual and country = 'B', (Sum(VALUES)-(value))/sum(VALUES),NULL()))

       

      But it's not working and no result.

       

      2nd formula-

      If (Client_type=Individual or country = 'A', (Sum(VALUES)-(value))/sum(VALUES),

      If (Client_type=Individual or country = 'B', (Sum(VALUES)-(value))/sum(VALUES),NULL()))

       

      Result is % of only Country is reflecting and % of country B getting incorrect calculation and also I used color coding for more than 90%,>85%,<85% but it's working only for country A and not working for country B

       

      3rd formula-

      If (Client_type=Individual or country = 'A', (Sum(AVALUES)-(value))/sum(AVALUES),

      If (Client_type=Individual or country = 'B', (Sum(BVALUES)-(value))/sum(BVALUES),NULL()))

       

      Result is % of only Country is reflecting and % of country B getting incorrect calculation and also I used color coding for more than 90%,>85%,<85% but it's working only for country A and not working for country B

       

      Can you please help me to fix this issue in qliksense.