Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a pivot table similar to this one:
Account | Segment | Month | Starting Balance | Measure 1 | Measure 2 | Measure 3 | Measure 4 | Ending Balance |
101 | A | 1 | 10 | 2 | 20 | 15 | Col (1) + Col (2) + Col (3) + Col (4) + Col (5) | |
2 | 20 | 4 | 10 | 5 | Col (1) + Col (2) + Col (3) + Col (4) + Col (5) | |||
3 | 3 | 6 | 5 | 20 | Col (1) + Col (2) + Col (3) + Col (4) + Col (5) | |||
Total | - | 33 | 12 | 35 | 40 | - | ||
B | ||||||||
C |
For Starting Balance column, I am using IF statement. If Month is 1, Starting Balance is last year balance (using Set Analysis), Above(Col 6) which is the value from ending balance col.
For Starting Balance and Ending Balance columns, Total value is missing.
I don't know why it is happening or how to fix it.
Thank you for your help in advance.
Hi @su_pyae ,
What version of Qlik Sense are you using?
By using classical operators like + each value must be a valide numerical value - otherwise the result will be NULL. To avoid any issues with non numerical values you may use a range-function like: rangesum(Value1, Value2, ...)
- Marcus