Qlik Community

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:

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.

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.

thomaslg_wq
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.

lironbaram
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?

thomaslg_wq
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?

lironbaram
Honored Contributor II

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

hi

here is a qlik sense file

Community Browser