How to filter data in list box level

[#1]

Hi....

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?

For better understanding PFA........

Regards,

Sh.

[Gysbert_Wassenaar]

See attached example.

[swuehl]

You probably need to handle year change in some way.

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.

See also:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/01/04/cyclic-or-sequential

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

[#4]

Hi Gysbert,

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

Regards,

Sh.

[Gysbert_Wassenaar]

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.