topic Re: How get the last 7 days data in QlikView

How get the last 7 days data

Fri, 13 Mar 2015 14:52:17 GMT

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

Re: How get the last 7 days data

MK_QSL — Fri, 13 Mar 2015 15:26:31 GMT

Check enclosed file...

Re: How get the last 7 days data

Fri, 13 Mar 2015 15:39:03 GMT

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

Regards

Krishna

Re: How get the last 7 days data

buzzy996 — Fri, 13 Mar 2015 15:46:28 GMT

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)

Re: How get the last 7 days data

Sat, 14 Mar 2015 05:27:50 GMT

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 !

Re: How get the last 7 days data

mukesh24 — Sat, 14 Mar 2015 07:05:14 GMT

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

Re: How get the last 7 days data

Sat, 14 Mar 2015 07:12:01 GMT

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

Re: How get the last 7 days data

buzzy996 — Mon, 16 Mar 2015 10:32:29 GMT

try this

Re: How get the last 7 days data

Mon, 16 Mar 2015 11:07:41 GMT

Thnx Shiva

Regards

Krishna