need urgent help

[#1]

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.

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling.

[#3]

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.

[Anonymous]

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...