topic Re: Default Selections in QlikView

Default Selections

Anonymous — Thu, 23 Jul 2015 10:20:32 GMT

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,

Re: Default Selections

sgrice — Thu, 23 Jul 2015 10:24:52 GMT

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.

Re: Default Selections

Kushal_Chawda — Thu, 23 Jul 2015 10:36:50 GMT

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

Re: Default Selections

Gabriel — Thu, 23 Jul 2015 10:46:53 GMT

Hi,

Another way might be to as part of your trigger LOCK those field that are relevant to user and clear AL.

Re: Default Selections

vardhancse — Thu, 23 Jul 2015 11:05:27 GMT

Triggers with alternate state might help you

Re: Default Selections

Anonymous — Thu, 23 Jul 2015 11:22:02 GMT

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,