Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
byrnel0586
Creator
Creator

Triggering Multiple Month Selections

Hi,

I need to create a trigger for a single tab in my app that when one month is selected, the prior 3 months are automatically selected also. Is there a way to do this? My months are labeled as Jan, Feb, Mar, etc.

Thanks.

2 Replies
MK_QSL
MVP
MVP

Consider that you have InvoiceMonth Field... If you have month field having different than InvoiceField, change name accordingly.

Create an Alterante State

Go to Document Properties - General Tab - Alternate States - Add - A

Now go to Document Properties - Triggers

Select InvoiceMonth from Field Event Triggers

On Select

Add Actions

Add

Selection - Select In Field

Field

InvoiceMonth

Search String

='(' &    

Month(MakeDate(Year(Today()), Max(InvoiceMonth)-2)) & '|' &        Month(MakeDate(Year(Today()), Max(InvoiceMonth)-1)) & '|' &       Month(MakeDate(Year(Today()), Max(InvoiceMonth))) & 

  ')'


Make sure you select A in Alternate State in Action Tab.


Now Create InvoiceMonth List box and assign Alternate State A for it.


Try to select any month.


Let me know if you are not getting desired output.

byrnel0586
Creator
Creator
Author

Thank you, but it is not working. I think it is because my months list box is static throughout each tab so when a new selection is made it flows throughout. I need a single tab to show all 4 months when 1 month is selected.