Cumulative trend (raising trend) % in Qliksense

[QS21]

Hi all,

I am trying to calculate Cumulative % and show it in a line chart. Below are the issues I am facing:

1. My x axis is allocation month which looks like 0,1,2,3,4

2. my lines are values of a category like A1, A2, A3

3. I have num variables bal and amt

4. Bal is denominator for my % calculation which is sum of BAL by Quarter/3 - and this result will be constant across POINT1 - it will e same for 0,1, 2,.... 32

5. AMT is Numerator which is Sum of AMT by Quarter/3 for each values in POINT1 - 0,1 2,3.

6.

Kindly help in achieving the table 2 formula in QlikSense

[QS21]

Attached the file with dummy data