Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using Aggr() function in Waterfall charts

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6787.Aggr-in-chart.xlsx:550:0]

Volume 1Volume 2Volume DeltaAUP 1AUP 2AUP DeltaPure Price (C * D)
52361515
4403210
78-1422-2
35-212-12
87123-1-1
2117433
292722314917Sum
18Expression Total
Pure Price formula = Volume 2 * AUP Delta
Total Mode for Pure Price is SUM and NOT Expression Total
I want to build a waterfall chart with NO dimensions and display ONLY Pure Price (see picture below from QV Finance sample app)
I think that solution is to use AGGR() function but I can not figure out how
All my attempts end with Total = 18, which is Expression Total and NOT 17, which is the right amount I want to have on the chart

1 Reply
Not applicable
Author

It could be done using aggr, but you'll need an ID field to uniquely identify each row. Then you could easily do sum(aggr([Volume 2] * [AUP Delta], RowID)).