topic Re: Trigger on date functions. in QlikView

Trigger on date functions.

Wed, 25 Nov 2020 16:16:04 GMT

I have expense Month-Year as below.I want to add a trigger to default to the rolling months period.

When I land on a page the trigger should default the Month-Yr from Aug - 2017 to June - 2018.How can I do that ?

Thanks much.

Re: Trigger on date functions.

sunny_talwar — Fri, 05 Aug 2016 16:46:22 GMT

I guess add a sheet level trigger like this:

='>=' & Date(MakeDate(2017, 8, 1), 'MMM-YYYY') & '<=' & Date(MakeDate(2018, 6, 1), 'MMM-YYYY')

This is assuming that Expense Month-Year is created like this in the script:

Date(MonthStart(DateField), 'MMM-YYYY') as [Expense Month-Year]

Re: Trigger on date functions.

Fri, 05 Aug 2016 18:49:48 GMT

yup...this is how I have the Month-year created but if I use (2017,8,1) every month I have to manually change it every month right ? Is there any way I can automate that ?

Re: Trigger on date functions.

sunny_talwar — Fri, 05 Aug 2016 18:53:24 GMT

What is the logic for choosing August 1st 2017 and June 1st 2018?

Re: Trigger on date functions.

maxgro — Fri, 05 Aug 2016 18:59:14 GMT

change the bold as your requirement

='>=' & Date(AddMonths(Today(),0), 'MMM-YYYY') & '<=' & Date(AddMonths(Today(),11), 'MMM-YYYY')

Re: Trigger on date functions.

sunny_talwar — Fri, 05 Aug 2016 19:01:58 GMT

But maxgro‌ today is 2016, I think with this logic, he might need this:

='>=' & Date(AddMonths(Today(), 12), 'MMM-YYYY') & '<=' & Date(AddMonths(Today(), 23), 'MMM-YYYY')