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: 
sidjustice
Contributor II
Contributor II

Help with displaying value progressing over time

HI

I have data which looks like this

DateObjectValue
9/1/13abc2
9/2/13def3
9/9/13ghi4
9/16/13jkl5
9/18/13abc1.8
9/20/13def2.5

I want to take snapshots at different dates say maybe every Sunday 9/7 9/14 and 9/21 and sum up the latest values for each available object. If nothing is selected, then a pivot table representing what I would like to see would look this

9/7/13     Total          5

               abc          2

               def          3

9/14/13     Total          9   

               abc          2

               def          3

               ghi          4

9/21/13     Total     13.7

               abc          1.8

               def          2.5

               ghi          4

               jkl          5

I have tried using aggr() but somehow I am not able to get it to work.

Any help would be appreciated

Thanks

Sid

0 Replies