Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Thanks,

1 Reply
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful