Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 & ')' )

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)