topic Re: need urgent help in QlikView

need urgent help

Mon, 22 Jul 2013 17:11:59 GMT

Hi.. I have a calendar month from Jan to Dec(PFA) ... and i am using one button to select last 3 months of data ..for that using BUTTON PROPERTIES-->ACTION-->SELECT IN FIELD-->SEARCH STRING(='>='&MonthEnd(max({1} Day), -2)), but it is showing May, Jun, July data but i need to disply Apr,May and June data only ..i tried in many ways ..but not getting please any one can help me how to get this..

Regards,

Sh.

Re: need urgent help

Gysbert_Wassenaar — Mon, 22 Jul 2013 17:16:12 GMT

Please read these two documents:

Re: need urgent help

Mon, 22 Jul 2013 17:38:18 GMT

Hi I read those documents , will take care that from next time onwards.., can you please let me know solution for my issue..

I have a calendar month from Jan to Dec ... and i am using one button to select last 3 months of data ..for that using BUTTON PROPERTIES-->ACTION-->SELECT IN FIELD-->SEARCH STRING(='>='&MonthEnd(max({1} Day), -2)), but it is showing May, Jun, July data but i need to disply Apr,May and June data only..

regards,

Sh.

Re: need urgent help

Anonymous — Mon, 22 Jul 2013 20:19:43 GMT

Trying to guess... The max date is the reload date - is it correct? If yes, it explains why you have May to July.
Next guess - you want the prevous three full months, that means the current month is not included. If this is correct, replace
MonthEnd(max({1} Day)
with
date((MonthStart(max({1} Day)-1))

Too many assumptions. Maybe your follow-up makes it clearer...