Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Trigger on date functions.

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 ?

Month-Year.GIF

Thanks much.

5 Replies

Re: Trigger on date functions.

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]

Highlighted
Not applicable

Re: Trigger on date functions.

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 ?

Highlighted

Re: Trigger on date functions.

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

Highlighted
MVP
MVP

Re: Trigger on date functions.

change the bold as your requirement

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

Highlighted

Re: Trigger on date functions.

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')