topic Re: Triggering Multiple Month Selections in QlikView

Triggering Multiple Month Selections

byrnel0586 — Tue, 21 Jun 2016 18:11:49 GMT

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.

Re: Triggering Multiple Month Selections

MK_QSL — Tue, 21 Jun 2016 18:55:43 GMT

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.

Re: Triggering Multiple Month Selections

byrnel0586 — Wed, 22 Jun 2016 13:07:45 GMT

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.