topic Weekley aggregations in QlikView

Weekley aggregations

Fri, 27 Nov 2009 15:47:08 GMT

Hello

I have a table which has a daily date and a numeric field called [assets] , using the load script I have defined date parameters using week , month , Year

I am attempting to aggregate [assets] by week within a chart which is fine but I alos want to show the change in aggregate [assets] . I have attempted to do this by using (current aggregate [assets] - before aggregate [assets]) but get nil returns .

Any ideas ?

parentco_friendname	Lyxor
Week	Aggegate AUM	% Change AUM
47	€13647
46	€11499
45	€14402

Thanks James

Weekley aggregations

prieper — Fri, 27 Nov 2009 17:11:59 GMT

You should apply ABOVE-formula without aggregation (aggregation is already defined by the week).
See the attached.

HTH
Peter

Weekley aggregations

Fri, 27 Nov 2009 18:48:45 GMT

I can just second the reply/answer from Peter. You should use the Above function to claculate the difference between the weeks.