Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Cummulative values on a line chart


Hi

I have a line chart that shows periodic values by year. The chart is calculating a variance % by period but what I need the chart to do is calculate the cummulative variance % each period. i.e bring forward the values from the previous period and recaclulate the total variance for the period

I've attached my QVW and the line chart is on the metrics tab

Any help would be appreciarted as I'm not sure if I need to do this in the load script or the chart properties

Thanks

1 Reply

Re: Cummulative values on a line chart

Community Browser