Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Clear All Selection with Background Filter


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!

11 Replies
Not applicable

Re: Clear All Selection with Background Filter

Hi,

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

Not applicable

Re: Clear All Selection with Background Filter

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").

Not applicable

Re: Clear All Selection with Background Filter

Joming,

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

Not applicable

Re: Re: Clear All Selection with Background Filter

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

sundarakumar
Valued Contributor II

Re: Clear All Selection with Background Filter

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

Not applicable

Re: Re: Clear All Selection with Background Filter

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.

Not applicable

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

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

NickHoff
Valued Contributor

Re: Clear All Selection with Background Filter

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.

Not applicable

Re: Re: Clear All Selection with Background Filter

Great! Thank you Padmaja and Sundarakumar for the solution!