Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Weekley aggregations

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

1 Solution

Accepted Solutions
prieper
Master II
Master II

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

HTH
Peter

View solution in original post

2 Replies
prieper
Master II
Master II

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

HTH
Peter

Not applicable
Author

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