7 Replies Latest reply: Apr 15, 2018 9:49 PM by Sasidhar Parupudi RSS

    QLiksense - Group By

    PKB MEHTA

      Hi,

       

      I have data as below

         

      QuarterMonthTarget
      Q1110000
      Q1210000
      Q1310000
      Q2420000
      Q3520000
      Q46

      20000

       

      In Qliksense frontend, I want to show the monthly values as shown in table

      But quarterly value for Q1 should be 10000, not the sum of all three(30000)

      and for Q2 it should be 20000, and not sum of all three (60000)

       

      When user selects on the  quarter filter, instead of sum of all three, only 10000 ( for Q1) and 20000 ( for Q2) should show in the chart.

       

      WHat is the way to achieve this? Can an alternate dimesnion be added in the same chart ? and aggr fucntion be used to add another variable, quarterly target, ?

       

      Please share the fucntion or way to achieve this