Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check enclosed file...
Check enclosed file...
Thanx alot Manish ...have been trying this for nearly 3 hrs..
Regards
Krishna
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)
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 !
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
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
try this
Thnx Shiva
Regards
Krishna