topic Clear All Selection with Background Filter in QlikView

Clear All Selection with Background Filter

Wed, 17 Sep 2014 18:20:39 GMT

Hello Community,

Does anyone know how I can keep a default selection on a sheet even when the Clear All Selection button is hit and if a Person is selected and then unselected?

Thank you kindly!

Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 18:24:03 GMT

Hi,

Try using locking feature to lock the desired selections on the fields.

Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 18:33:27 GMT

Hi,

Thanks for your response, but that won't work because if I lock selection for Persons A-Z, I cannot just select Person B or C. I would like to apply a filter to a field that is not in a list box (e.g. DEPARTMENT = "Sales").

Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 19:02:20 GMT

Joming,

Could you post an example to get a clear understanding??

Re: Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 19:46:30 GMT

Hi Kiruthi,

Here's a sample:

I have a sheet trigger on activate that filters to Grade='A'. But notice if you hit Clear Selection, you lose this filter. Likewise, if you select anything in the CLIENT list box and then unselect it, you lose the Grade='A' filter. I would like the Grade='A' filter to persist no matter what selections are made throughout the sheet. Hope that is clear...

Thank you for any suggestions,

Joming

Re: Clear All Selection with Background Filter

sundarakumar — Wed, 17 Sep 2014 19:53:31 GMT

Use always one selected on the particular filed. In the list box the option is available in general tab. Make sure u have selected only one value in the list box, this will make this option available..

-Sundar

Re: Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 19:58:16 GMT

Hm...I don't have a list box with the Field that I need the filter to be applied on (The field, "Grade", in the case of the Sample). In the real app, such a list box would cloud the look of the app.

Re: Re: Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 20:36:46 GMT

Use the suggestion by Sundarakumar and hide the list box. Something like this.

Re: Clear All Selection with Background Filter

NickHoff — Wed, 17 Sep 2014 20:39:56 GMT

Click on setting > document properties, then click triggers. Once there you will see "Field Event Triggers", select the name of the field you would like to keep selected and add an action to lock field.

Re: Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 22:35:42 GMT

Great! Thank you Padmaja and Sundarakumar for the solution!

Re: Clear All Selection with Background Filter

nagaiank — Wed, 17 Sep 2014 22:41:12 GMT

You may have default selections as a bookmark.

Create a button with two actions (1) Clear all (2) Apply your bookmark having your desired default selections

Hope this helps.

Re: Re: Clear All Selection with Background Filter

Wed, 17 Sep 2014 22:41:15 GMT

Thank you for that recommendation Nick. I needed it at the sheet level, so I just added an action to lock field in sheet properties>triggers.