Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6787.Aggr-in-chart.xlsx:550:0]
| Volume 1 | Volume 2 | Volume Delta | AUP 1 | AUP 2 | AUP Delta | Pure Price (C * D) | ||||
| 5 | 2 | 3 | 6 | 1 | 5 | 15 | ||||
| 4 | 4 | 0 | 3 | 2 | 1 | 0 | ||||
| 7 | 8 | -1 | 4 | 2 | 2 | -2 | ||||
| 3 | 5 | -2 | 1 | 2 | -1 | 2 | ||||
| 8 | 7 | 1 | 2 | 3 | -1 | -1 | ||||
| 2 | 1 | 1 | 7 | 4 | 3 | 3 | ||||
| 29 | 27 | 2 | 23 | 14 | 9 | 17 | Sum | |||
| 18 | Expression 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 | ||||||||||
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)).