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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
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)).