Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
marcel_h
New Contributor

Pivot: Calculation based on the pre-value and the month from column

Hello,

I challenge to compute a value in a pivot table based on each month and its pre-value.

I have tried a few with rangesum () and before (), but I just can not get the result you want.

 

Condition:

I have a pivot table. In the columns I have the months 1-12. Then I have a selective metric for each month. The new calculated measure is based on the corresponding month and the pre-value.

1. Example value for month 1 is the original value.

2. Value for month 2 is "original value * 2 - sum(pre-values)."

3. Value for month 3 is "original value * 3 - sum(pre-values)".

4. ......

 

Please can anyone help me?

Thanks in advance.