topic Re: Need Help??? in QlikView

Need Help???

paulwalker — Sun, 09 Mar 2014 16:28:31 GMT

HI Community,

PFA,

i want to show last 7 days based on my orderdate field...........

Suppose...

DateField:

14/3/2014

19/2/2014

19/3/2014

21/2/2014

21/3/2014

23/3/2014

25/2/2014

25/3/2014

26/3/2014

28/2/2014

28/3/2014

if i am select 23/3/2014 i want to show below 7 days dates

14/3/2014

19/2/2014

19/3/2014

21/2/2014

21/3/2014

if i am select 28/3/2014..

last 7 days in my date field dates only..........

Hope this Understand.........

Thanks in Advance..............

Re: Need Help???

maxgro — Sun, 09 Mar 2014 17:52:30 GMT

see attachment

I think your expression should be

sum({$ <OrderDate=,ID={">=$(=(Max(ID))-7)<=$(=(Max(ID)))"}>} Cost)

or (EDIT)

sum({$ <OrderDate=,ID={">=$(=(Max(ID))-6)<=$(=(Max(ID)))"}>} Cost)

I changed your date format in first page: you have this data

114, 19/3/2014, Book15, 290

so format should be

SET DateFormat='DD/MM/YYYY';