5 Replies Latest reply: Feb 13, 2017 11:46 AM by Kaushik Solanki RSS

    QlikSense-Add dummy value in Field and sum up the records

    vivek pv

      Hi Experts,

      I have a data like below

      NameSAL
      ABC100
      DEF200
      GH50
      IKJ10

      now I want to add one dummy value under and I need to sum up the specified records under SAL

      Like,

      NameSAL
      ABC100
      DEF200

      GROUP 1 SUM

      300
      GH50

      GROUP 2 SUM

      50

      G1+G2 Sum

      350

      IKJ10

      GROUP 3 sum

      10

      TOTAL360

       

      In the above table GROUP 1 SUM is a dummy column which will sum SAL of ABC+DEF

      I want to specify how many rows are need to be summed.

       

       

      Thanks,

      Vivek