Help with displaying value progressing over time

sidjustice — Tue, 24 Sep 2013 21:03:19 GMT

I have data which looks like this

Date	Object	Value
9/1/13	abc	2
9/2/13	def	3
9/9/13	ghi	4
9/16/13	jkl	5
9/18/13	abc	1.8
9/20/13	def	2.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

topic Help with displaying value progressing over time in QlikView

Help with displaying value progressing over time