How get the last 7 days data

[#1]

Hi All,

How to get the last 7 days data, 6 days, 5 days  data on bar chart as per the user selection. Here I have created a button for 7 days with trigger (='=New_Date>(Today() - 7)' ). Again I created another button for 6 days button. Instead of creating this stuff multiple times, is there any other solution where user can select the same values through list box.

Thanks in advance

Regards

Krishna

[MK_QSL · Accepted solution]

Check enclosed file...

[#3]

Thanx alot Manish ...have been trying this for nearly 3 hrs..

Regards

Krishna

[buzzy996]

u can also try,by creating one variable (vDays) ask user to put any value in that variable to see those many days bars into chart,by using the below exp.

SUM({<Date = {">$(=Date(Max(Date)-vDays))<=$(=Date(Max(Date)))"}>}Sales)

[#5]

Hi Manish,

I have tried your expression according to my requirements, but for some reason its not working. Could u please help me in achieving same in attached qvw.

I have few other queries Manish, regarding the triggers which are in qvw( 7 days, 6 days, 5days). when i press them in order i can see the changes but if do it in the reverse order..its not happening.

And finally Manish ..would u pls suggest me reference guide for qlikview expressions as I'm facing difficulty in writing expressions

Thnx in advance !

Regards

Krishna !

[mukesh24]

Hi Krishna,

Create User Input Box where user can enter number of days & use these variable to deduct number of days from selected date.

Regards,

Mukesh

[#7]

Hi Mukesh,

Would you please help me acheving that in qvw which is posted above.., Manish has replied with correct answer but still I'm unable to get that as per my requirement .

Thnx

Krishna

[buzzy996]

try this

[#9]

Thnx Shiva

Regards

Krishna