topic Re: How to filter data in QlikView

How to filter data

Mon, 22 Jul 2013 19:03:04 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 to get this..

Regards,

Sh.

Re: How to filter data

swuehl — Mon, 22 Jul 2013 19:15:45 GMT

Maybe like this?

='>='&MonthEnd(max({1} Day), -3)&'<'&Monthend(max({1} Day))

Re: How to filter data

Anonymous — Mon, 22 Jul 2013 19:58:31 GMT

try with this...

='('& month(MonthEnd(max({1} OrderDate), -1)) & '|' & month(MonthEnd(max({1} OrderDate), -2))& '|' & month(MonthEnd(max({1} OrderDate), -3))& ')'

Re: How to filter data

Anonymous — Mon, 22 Jul 2013 19:59:13 GMT

='('& month(MonthEnd(max({1} Day), -1)) & '|' & month(MonthEnd(max({1} Day), -2))& '|' & month(MonthEnd(max({1} Day), -3))& ')'

Re: How to filter data

Tue, 23 Jul 2013 04:03:03 GMT

Thanks to All for the reply ...Itried those conditions but are not helpful...please suggest some more conditions..

Regards,

Sh.

Re: How to filter data

Tue, 23 Jul 2013 04:03:21 GMT

Thanks to All for the reply ...I tried those conditions but are not helpful...please suggest some more conditions..

Regards,

Sh.

Re: How to filter data

Tue, 23 Jul 2013 04:03:44 GMT

Thanks to All for the reply ...I tried those conditions but are not helpful...please suggest some more conditions..

Regards,

Sh.