Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Need Help???

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..............

1 Reply
maxgro
MVP
MVP

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';

Clipboard02.jpg