topic Re: Need urgent reply in QlikView

Need urgent reply

Sun, 21 Jul 2013 16:02:50 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 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..

Thanks & Regards,

Sh.

Re: Need urgent reply

a_mullick — Mon, 22 Jul 2013 11:40:23 GMT

Hi,

Do you mean if the current month is July, then show Apr, May, Jun; if the current month is Aug, then show May, Jun, Jul?

Azam

Re: Need urgent reply

a_mullick — Mon, 22 Jul 2013 13:20:03 GMT

Hi,

Here is a solution which may work for you. As far as I can see, you need to have a lower limit and an upper limit for the 3 month period e.g. 01/04/2013 - > 30/06/2013 to select a 3 month period. I havevn't used the select fields action before, but it seem quite tricky to get something like a logical AND when you working with dynamic expressions, but using the Toggle Select action seems to work. I've set this up to dynamically select the 3 previous months, relative to the month you're in.

Hope it helps,

Azam

Re: Need urgent reply

narender123 — Mon, 22 Jul 2013 13:35:32 GMT

Hi,

See the attached file.

Thanks