topic Button to select last 12 Months in QlikView

Button to select last 12 Months

Thu, 14 Jul 2011 14:20:38 GMT

Hello

I want to create a button which when you click selects the last 12 month in a particular list box. I've tried this by setting the actions on the button and it works fine. However, when I try to use a variable to contain the date 12 months ago it doesn't work. What am I doing wrong? Please see the attached example.

Thanks for your help!

James

Button to select last 12 Months

Thu, 14 Jul 2011 15:29:10 GMT

Hi,

You have to write in the second button in the search string this one

='>='&'$(twelveago)'

and it will works

Best wishes

Button to select last 12 Months

Fri, 15 Jul 2011 14:04:31 GMT

This formule is the one i use, when i want to select the past 12 months

='>' & date(addmonths(today(), -13),'YYYYMM') & '<=' & date(today(),'YYYY')&(MonthMin1)

MonthMin1 is a variable.

I set this variable whit this code:

=text(date(today(),'MM'))

I hope this helps you

Greetz,

Dirk

Button to select last 12 Months

Fri, 15 Jul 2011 14:06:09 GMT

This is a yearmonth construction

Greetz,

Dirk