topic Cummulative using Set Analysis in QlikView

Cummulative using Set Analysis

Mon, 14 Feb 2011 16:35:26 GMT

Hi All,

I have a trend of sum(revenue) on monthly basis.. But now i need to make this trend as the cummulative Trend. ie the subsequent month will go on suming the revenue.. I d'nt want to use the Full accumlation function as available in the Property box.. Want to use it using set analysis or some other way..

Please try to help me..

Thanks in Advance..

Regards,

Ankit

Cummulative using Set Analysis

Mon, 14 Feb 2011 18:10:40 GMT

Plz any one can repy...

Cummulative using Set Analysis

pover — Mon, 14 Feb 2011 18:47:25 GMT

Use the above() function.

above(sum(Sales)) + sum(Sales)

Cummulative using Set Analysis

Tue, 15 Feb 2011 08:35:37 GMT

Thanks Karl for the reply.. But is there any way we can use by Set Analysis alos?

Thanks,

Ankit

Cummulative using Set Analysis

pover — Tue, 15 Feb 2011 22:28:17 GMT

Sadly, you cannot reference the dimension value of a chart in the set analysis of an expression. Go to this discussion http://community.qlik.com/forums/t/40894.aspx where John has uploaded an example that might be interesting to you.

Regards.