Create cumulative line chart as percentage - Qlik Community

kstakpcn · ‎2020-11-16

Hello all,

Would it be possible to create a line chart as this?

The amount calculated is in % and that is as shown below in the formula a cummulative. For instance, in a given month, lets say 7 - July, the % is calculated as the total sum from january to july of value A devided by the same range of sum for value B.

Thank you very much in advance!

Anil_Babu_Samineni · ‎2020-11-16

Yes, For me it is possible since you are using Qlikview. Please share some sample data to work

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

kstakpcn · ‎2020-11-16

Thanks for the reply. In what format can I share data? excel? Would that be ok?

Anil_Babu_Samineni · ‎2020-11-16

That works otherwise, Share the QVW with excel file to save time

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

kstakpcn · ‎2020-11-16

There please find attached the excel file with the demo data. Thank you so much!

edwin · ‎2020-11-16

try this:

=rangesum(above(B_Amount,0,RowNo()))/rangesum(above(Gross_Amount,0,RowNo()))

make sure you sort by month

kstakpcn · ‎2020-11-17

Thank you that was really helpful,

To make it more challenging, would it be however possible to consider the rolling effect from January and on and leave December 2019 alone as is?

The offset variable doesn't produce me the correct results if i were to set it as 1 or 2.

Attached is the Excel with the formula and the december 2019 added in it.