Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Monthly differences


Hello QVer,
I have an expression in a straight table like "(sum(A)-sum(B))/sum(B)" which gives results as
2,88%
3,95%
2,36%

Now I want to have as result (as monthly differences)
-
1,07%
-1,59%
and so on.

I tried <before>, <peek> etc. Nothing helped.

Can anybody please point me to the right calculation. Thanks in advance.
Best regards dj_skbs

1 Solution

Accepted Solutions
Not applicable
Author

Hello dj_skbs,

let me call your expression in your straight table "percentage". Then try an expression like this:

above([percentage])-[percentage]


Regards,

Roland

View solution in original post

2 Replies
Not applicable
Author

Hello dj_skbs,

let me call your expression in your straight table "percentage". Then try an expression like this:

above([percentage])-[percentage]


Regards,

Roland

Not applicable
Author

Hello Roland,

That's it. I failed to see <above>. Thank You. dj_skbs