using Aggr() function in Waterfall charts

Thu, 03 Dec 2009 03:47:59 GMT

[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

using Aggr() function in Waterfall charts

Thu, 03 Dec 2009 04:55:10 GMT

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)).

topic using Aggr() function in Waterfall charts in QlikView

using Aggr() function in Waterfall charts

using Aggr() function in Waterfall charts