topic Re: Trigger a selection with an expression in QlikView

Trigger a selection with an expression

Tue, 11 Mar 2014 09:24:48 GMT

Hello,

I want to create a trigger on the tab activation.

I have a field Date(format DD.MM.YYYY) and i would like to select all values from the past year to the previous month.

For example, today i would like the trigger to select only the values from February 2013 to February 2014.

Can someone help me to build the expression which could do this please?

The current month is in a variable Month and the current year in the variable Year.

Thanks,

Best Regards,

Loïc

Re: Trigger a selection with an expression

MK_QSL — Tue, 11 Mar 2014 09:36:47 GMT

Something like enclosed file?

If you want date from last year to today

i.e. 12/03/2013 to 11/03/2014 use

='>$(=AddYears(Today(),-1))' in expression with TempDate as Dimension (Select in Field)

You can also use

='>$(=AddMonths(Today(),-12))'

Re: Trigger a selection with an expression

sudeepkm — Tue, 11 Mar 2014 09:44:03 GMT

You may create a new field in the script as a YOY Flag using the below expression.

if(Date <= Today() and Date >= MonthStart(AddMonths(Date(Today()), -13)),1,0) as YOYFlg,

The new YOYFlag will be 1 if your Date is between today and last 13 months else it will be 0.

Now you can add action to a navigation button just Select in Field YOYFlag as 1.

Please take a look at the attachment.

Re: Trigger a selection with an expression

Tue, 11 Mar 2014 09:57:10 GMT

Thank you for your very helpful answer!

But is this possible to select from last day of the previous month last year to the last day of the previous month this year (from 28/02/2013 to 28/02/2014)?

Re: Trigger a selection with an expression

MK_QSL — Tue, 11 Mar 2014 10:03:13 GMT

Change your search string as below...

='>=$(=MonthEnd(Today(),-13))<=$(=MonthEnd(Today(),-1))'

Re: Trigger a selection with an expression

sudeepkm — Tue, 11 Mar 2014 10:03:51 GMT

You can use MonthEnd function.

MonthEnd(AddMonths(Date(Today()), -13))