Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

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

Re: CUMULATIVE SET ANALYSIS EXPRESSION

Try this

RangeSum(Expression, -Above(Expression))

2 Replies

Re: CUMULATIVE SET ANALYSIS EXPRESSION

Try this

RangeSum(Expression, -Above(Expression))

Digvijay_Singh
Honored Contributor III

Re: CUMULATIVE SET ANALYSIS EXPRESSION

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.

Community Browser