Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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