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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.