Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Consider a demo application at -
http://us-b.demo.qlik.com/detail.aspx?appName=Pilotage%20Commercial.qvw
Now, we have a requirement, where suppose, in the application, user is navigating from Clients to Analyse, the Region filter should get cleared as the Region filter is not present in the sheet.
Same if user navigates from Analyse to client, the non related sheet filters should get clear.
In our application, we have around 180 fields. To clear at least 20 fields per sheet will have more number of Triggers and impact on Performance.
Do you have any idea, through which this can be achieved.
Regards,
MK
I would do it the other way around.
Rather than think of the field to clear. Think of the one filter that matters for that tab.
So if they navigate to the Client tab then "select in field" All available Clients for current selection and then clear all others filters.
You can create two triggers.
On activate sheet, create 1st trigger as "Clear All".
2nd trigger will be the required selection for that sheet . Use "Select in field" trigger for that
Hi,
Another way might be to as part of your trigger LOCK those field that are relevant to user and clear AL.
Triggers with alternate state might help you
Thanks for the quick replies,
In our case, we have around 30 filters in one screen, out of which 12 are there in another screen, for which the selections should carry forward.
If we clear All, selected fields will not be carry forward.
Please suggest.
Regards,
MK