0 Replies Latest reply: Sep 27, 2016 3:03 AM by Parikshit Sadegaonkar RSS

    Aggregated values in table

    Parikshit Sadegaonkar

      Hi Expertise

       

      I am new to Qlik Sense. Currently I am working on Set Analysis part but not able to understand how will it work. Could you please assist me to get basic understandingof it.

       

      I have sample data where data is divided Qtr wise as below. I have requirement like to show sales year wise as shown in last column.

       

      Could you please assist me which function work here ?

       

       

      Year Qtr      Sales Year Wise Sales  

       

      2004Q11001000
      2004Q22001000
      2004Q33001000
      2004Q44001000
      2005Q15002600
      2005Q26002600
      2005Q37002600
      2005Q4800

      2600