Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I haven't got its meaning,perhaps you need more details for it.
You should look at "set analysis" ==> Learning Set Analysis from Scratch
It allows you to kind of filter on fields when calling a measure.
hi
have a look at the attach example it automatically find the current month
and splits the number
Qlik Sense shows this file as empty.
What do I do wrong?
This a qlikview file. Not a qlik sense file.
Is it possible to prepare such a file for Qlik Sense?
hi
here is a qlik sense file