7 Replies Latest reply: May 16, 2018 3:48 PM by Hassan Javaid RSS

    sum at a level in data

    Hassan Javaid

      Hi - Have a problem, how can I sum at a level in QlikSense . For example I have the following data

      Item , Data Set 1, Data Set 2, units

      A, 10, 5, 3

      B, 12, 2, 10

      C, 4, 2, 2


      I need to get a sum of   (Data Set 1 - Data Set 2)* Units

      for item A 15 which is (10-5)*3

      for item B 100 which is (12-2)*10

      for item C 4 which is (4-2)*2

       

      The KPI I am looking for is 119