Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

I have to make a straight table with 1 column showing Cumulative Difference.

In my table, I have week, month, No of QOE Subscribers.

I have to create a new column, and place cumulative difference of the QoE Subscribers in that column. Also, the first row should be null (0) and the cumulative difference should start from the 2nd column.

Ex -

WeekMonthQoe SubscribersCumulative Difference
Week1Jan230
Week1Feb252
Week1Mar22-3
Week1Apr308

Any help is appreciated. Thanks.

Deepali

Tags (1)
2 Replies
MVP
MVP

Re: I have to make a straight table with 1 column showing Cumulative Difference.

May be this:

If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscriber], -Above(TOTAL [Qoe Subscriber])))

silambarasan130
Contributor II

Re: I have to make a straight table with 1 column showing Cumulative Difference.

This may be help you,

If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscribers] - Above(TOTAL [Qoe Subscribers])))