Select Only Last 5 week day and day using Set analysis

[#1]

Hi,

I want to do sales analysis for last five week day and if i select one week day in list box, based on the selection it should list last 5 selected week day.

For Eg:

If i select only Monday, it should list last 5 monday.

Kindly help!

Thanks,

Selva

[phaneendra_kunc]

Do u have a sample data to work with?

[#3]

Hi Phaneendra,

Please find the attached sample data

Selva

[phaneendra_kunc · Accepted solution]

see attached....

[#5]

Thanks Phaneendra..

It's working.. Is there any option available to set week days from (Sunday to Thursday) by default.

Selva

[phaneendra_kunc]

May be this will help...U have to manage that in your calendar

http://community.qlik.com/message/217120#217120

http://community.qlik.com/message/90934#90934