Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

CUMULATIVE SET ANALYSIS EXPRESSION

HELLO;

i have straight table  ,contains two clomun , value per month , so i want to create new table with the difference between two months

Capture.PNG

Thank u

1 Solution

Accepted Solutions
sunny_talwar

Try this

RangeSum(Expression, -Above(Expression))

View solution in original post

2 Replies
sunny_talwar

Try this

RangeSum(Expression, -Above(Expression))

Digvijay_Singh

Do you have same dimension in the new table. You need to use Above function for this.

If you have Month and value columns, then use Sum(Value)-Above(Sum(Value)), The first value may show null as there is no above value to that, You can surround it with Rangesum or Alt functions to show same column value or 0.