topic Cumulative value using Aet analysis in QlikView

Cumulative value using Aet analysis

Wed, 08 Sep 2010 13:23:50 GMT

Hi,

Can we calculate cumulative value of amount w.r.t. Location on monthwise using set analysis.

I need to do it by using set analysis only.

I have a variable mindate .

For data and sample output , please refer the attached spreadsheet.

Regards,

Veman Reddy

Cumulative value using Aet analysis

johnw — Wed, 08 Sep 2010 19:16:04 GMT

A set is only calculated once for the entire chart, not once per row in your chart. So if I understood your question, it is not possible to do a cumulative value with only set analysis. In your example, though, it could be as simple as putting a checkmark next to full accumulation on the expressions tab for the second expression.

Cumulative value using Aet analysis

Thu, 09 Sep 2010 04:44:34 GMT

Hi John,

Thanks for your response and also your help in this community.

But I need to do it in pivot table and need to display current quarter information of all locations but It should consider the cumulative of all previous months without displaying in the chart.

Thanks & Regards,

Veman Reddy