2 Replies Latest reply: Apr 15, 2018 8:51 AM by Sarfaraz Sheikh RSS

    Row level sum in Qliksense without Aggregation

    Sarfaraz Sheikh

      Dear Folks,

       

      I have the below data and i want to calculate below things

      1- CoreRangeOn Premise = No of CR Pack On + No of CR Bulk On

      2> Core Sold On premise = (No of CR Pack on * 9LE Pack on) + (no of CR Bulk on * 9LE Bulk)

       

      However After doing the multiplication in second column i want to show the sum of record where i get one. like in below chart if you see there total 5 times 1 appears and i want to show the row level sum against particular outlet.

       

      OR in short the logic is No of CR Pack on and 9LE Pack on  is 1 then give 1 else 0 and then do the Sum of that 1's.


      Note : Please advice the solution wihtout aggregation function as i have already done it and it is taking very long time to open chart in front end as i have very huge data. I want it to be done without Aggr function.


      Is there anyway to do it in set analysis. All the above columns are calculated column and I am using Qliksense and help would  be much appreciated.

      gwassenaar; hic  please comment

      snap1.png

       

       

      OutletProduct (IPL)No of CR Pack OnNo Of CR Bulk OnCore Range On premisee9LE Bulk9LE Pack onCore Sold Onm premise
      2040038545356011000
      2040038545778000100
      2040038545779000010
      2040038545791000010
      2040038545794011101
      2040038546488000100
      2040038546598000100
      2040038546896000010
      2040038546979101000
      2040038547128011101
      2040038547137101000
      2040038547265101000
      2040038547430011000
      2040038547492000010
      2040038547739011000
      2040038547768011101
      2040038547771101000
      2040038547853101000
      2040038547875011101

       

      Thanks

      Sarfaraz