topic Re: How to filter data in list box level in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514345#M192147 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>Thanks for the reply , first 2 cases are fine ..but for for displying last 9 months it has to show last year Oct , Nov , Dec data and this year Jan to Jun...</P><P></P><P>Regards,</P><P>Sh.</P></BODY></HTML> Tue, 23 Jul 2013 16:04:20 GMT 2013-07-23T16:04:20Z How to filter data in list box level https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514342#M192144 <HTML><HEAD></HEAD><BODY><P>Hi....</P><P>I have a month column having data from Jan to Dec and i am taking this as List box, my requirement is i need to use one button to disply last 3 months of data (Apr, May, Jun) at a time by one clik ...is it possible? </P><P></P><P>For better understanding PFA........</P><P></P><P>Regards,</P><P>Sh.</P></BODY></HTML> Tue, 23 Jul 2013 15:39:32 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514342#M192144 2013-07-23T15:39:32Z Re: How to filter data in list box level https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514343#M192145 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Tue, 23 Jul 2013 15:53:49 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514343#M192145 Gysbert_Wassenaar 2013-07-23T15:53:49Z Re: How to filter data in list box level https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514344#M192146 <HTML><HEAD></HEAD><BODY><P>You probably need to handle year change in some way. </P><P></P><P>It might be better to apply the select in field action to a field that is continouus across the year change, i.e. having an underlying date value.</P><P></P><P>See also:</P><P><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/01/04/cyclic-or-sequential" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/01/04/cyclic-or-sequential">http://community.qlik.com/blogs/qlikviewdesignblog/2013/01/04/cyclic-or-sequential</A></P><P><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields</A></P><P></P><P></P></BODY></HTML> Tue, 23 Jul 2013 16:01:19 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514344#M192146 swuehl 2013-07-23T16:01:19Z Re: How to filter data in list box level https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514345#M192147 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>Thanks for the reply , first 2 cases are fine ..but for for displying last 9 months it has to show last year Oct , Nov , Dec data and this year Jan to Jun...</P><P></P><P>Regards,</P><P>Sh.</P></BODY></HTML> Tue, 23 Jul 2013 16:04:20 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514345#M192147 2013-07-23T16:04:20Z Re: How to filter data in list box level https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514346#M192148 <HTML><HEAD></HEAD><BODY><P>Your Month field is independent of the year. That means it can't be used to make a selection based on years. You can use the Day field instead. See attached example.</P></BODY></HTML> Tue, 23 Jul 2013 16:32:31 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-list-box-level/m-p/514346#M192148 Gysbert_Wassenaar 2013-07-23T16:32:31Z