# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

Hello.

I have a table like below:

 NAME TYPE JAN FEB MAR APR MAY JUN JUL … name1 type1 482 488 467 27 205 88 132 … name1 type2 231 237 216 114 122 130 120 … name1 type3 0 6 -15 41 26 187 46 … name2 type1 14 20 -1 194 182 208 74 … name2 type1 141 147 126 119 116 107 102 … name2 type1 598 604 583 90 18 45 97 … name2 type3 239 245 224 57 129 62 163 … name2 type3 0 6 -15 56 95 75 30 … name3 type2 7 12 -8 164 231 56 145 … name3 type2 865 871 850 203 4 202 48 … name3 type2 -84 -79 -99 67 23 176 215 …

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.

7 Replies
Not applicable

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

I haven't got its meaning,perhaps you need more details for it.

Contributor III

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

You should look at "set analysis" ==> Learning Set Analysis from Scratch

It allows you to kind of filter on fields when calling a measure.

Honored Contributor II

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

hi

have a look at the attach example it automatically find the current month

and splits the number

Not applicable

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

Qlik Sense shows this file as empty.

What do I do wrong?

Contributor III

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

This a qlikview file. Not a qlik sense file.

Not applicable

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

Is it possible to prepare such a file for Qlik Sense?

Honored Contributor II

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

hi

here is a qlik sense file