Last 3, 9, 15, 150 days

[#1]

Hi all!

I'm trying to build smart list box.

I have a daily data for about 5 years and I want to build a list box/button for my users when they can select if they want to see

1) All the available data

2) Last 3 days

3) Last 9 days

4) Last 15 days

5) Last 150 days

any suggestions?

[saradhi_it]

i think in the list box  you can options like per year

1) All the available data

2) Last 1 year

3) Last 2 years

4) Last 3 years

5) Last 4 years

[#3]

can you give an example?

[ashfaq_haseeb]

Hi,

Have a look at below post.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/06/dynamically-selecting-timeframes

Regards

ASHFAQ

[saradhi_it]

i think by creating a input field or creating a multibox...if you developed the script option,,,

[MayilVahanan · Accepted solution]

Hi

Give 5 button to select the user. 

Based on that, display the chart using set analysis.

Ex:

By Selecting button - Last 3 days:

Sum({<DateField = {">=$(= Date(Max(DateField)-3),'DD/MM/YYYY')"}>}Sales)

By Selecting button - Last 9 days:

Sum({<DateField = {">=$(= Date(Max(DateField)-9),'DD/MM/YYYY')"}>}Sales)

You can use dynamically by assigning the values in a variable.instead of using 3 or 9..

[#7]

cool it worked! thanks guys!