Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative value using Aet analysis

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

2 Replies
johnw
Champion III
Champion III

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.

Not applicable
Author

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