Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Trigger that selects month start to previous month

Hi all,

I'd like a trigger to select every month starting from the beginning of the year to the previous month. I have a variable as previous month and a month number field. Can someone please assist. I have already made a trigger that selects the current year I only need this one to select for example if it was april select month 1,2,&3.


1 Reply

Re: Trigger that selects month start to previous month

May be this string for search trigger and definition as Month-field or create 3 variables then pause those

If(Month-field = Month(Today()), '(' & Max(Month) | Max(Month)-1 | Max(Month)-2 & ')' )

Life is so rich, and we need to respect to the life !!!
Community Browser