topic Re: Clear other fields for multiple fields in QlikView

Clear other fields for multiple fields

Fri, 04 Jan 2013 15:24:29 GMT

I have 5 list boxes as filters and 2 multi boxes(Date filters) with year,day and Month fields as filters.....I have 4 tabs(sheets)....when I select any values in list boxes it will change in all 4 sheets, and in the same way with multiboxes.....but when I go to next sheet I want only the multi boxes(date filters) to clear all, and list box selections should remain as it is in previous sheet......I went trough community and found that clear other fields can do.....but I am unable to specify multiple fields in clear other fields.....thanks

Re: Clear other fields for multiple fields

adamwilson — Fri, 04 Jan 2013 15:33:40 GMT

Instead of using Clear Other use a Clear Field action for each field you want to clear.

Re: Clear other fields for multiple fields

Fri, 04 Jan 2013 15:36:59 GMT

tq....I dont find ant action saying Clear field....I am using QV9 I have clear alla nd clear other fields.....

Re: Clear other fields for multiple fields

adamwilson — Fri, 04 Jan 2013 16:01:20 GMT

I'm not sure if Clear Field is available in QV9

In that case you need to add multiple actions to the trigger in order to clear one selection:

Lock All

Unlock Field (the field you want to clear)

Clear All

Unlock All

Re: Clear other fields for multiple fields

thomduvi83 — Fri, 04 Jan 2013 16:19:56 GMT

You can also try :

"Select in Field" action with nothing in "Search string" to remove a selection in one field.

It's working well in V11...