7 Replies Latest reply: Nov 28, 2016 2:28 PM by Liron Baram RSS

    Easily change how many months to sum in a Table / Pivot table

    Don Andress

      Hello.

       

      I have a table like below:

       

      NAMETYPEJANFEBMARAPRMAYJUNJUL
      name1type14824884672720588132
      name1type2231237216114122130120
      name1type306-15412618746
      name2type11420-119418220874
      name2type1141147126119116107102
      name2type159860458390184597
      name2type32392452245712962163
      name2type306-1556957530
      name3type2712-816423156145
      name3type2865871850203420248
      name3type2-84-79-996723176215

       

      Is there a simple way to sum a variable number of columns?

      For example, it's APR so I'd like to sum JAN-APR and separately MAY-DEC.

       

      Let's say I run a monthly presentation in Qlik Sense and I have to prepare an app each month - how to do the above in a simple way so I didn't have to change a lot of formulas each month, given that the re?

      In ex. in Excel I can create a formula where then I only need to change one cell content and everything calculates accordingly.