topic Previous 7 days data when a date is selected in QlikView

Previous 7 days data when a date is selected

renjithpl — Thu, 26 Apr 2012 11:33:49 GMT

Hi All,

I have to find sum of sales of previous 7 days when i select a date (including the selected date).

Any idea ?

Regards

Renjith

CELAMBARASAN — Thu, 26 Apr 2012 11:40:30 GMT

Hi,

Try this

Sum({<DateField={">=$(=Max(Floor(Num(DateField))-7)<=$(=Max(DateField))"}>} Sales)

renjithpl — Thu, 26 Apr 2012 11:56:06 GMT

Thanks for the reply, but its not working!!

CELAMBARASAN — Thu, 26 Apr 2012 12:08:56 GMT

Sum({<DateField={">=$(=Date(Max(Floor(Num(DateField))-7))<=$(=Date(Max(DateField)))"}>} Sales)

SunilChauhan — Thu, 26 Apr 2012 13:12:09 GMT

see the attched file

hope this helps

renjithpl — Thu, 26 Apr 2012 13:35:39 GMT

I want it in a text box, i dont know for what reason, it shows the sales only for the selected date, its not returning for 7 days sales.

SunilChauhan — Thu, 26 Apr 2012 13:47:26 GMT

in expression replace 7 with 6

and copy to text

see the attched file

hope this may helps