topic Re: How to Clear Multiple Fields in QlikView

How to Clear Multiple Fields

Wed, 10 Sep 2014 07:42:34 GMT

Hi,

I have a requirement wherein out of the 20 selections made i need to clear 17 of them and keep the other 3 selections as is and also the use must be able to change the selections made on these 3 fields.Please let me know how this could be acheived,I tried using the clear other field action and giving the field value as (Field1|Field2|Field3).But it does not work

Re: How to Clear Multiple Fields

tresB — Wed, 10 Sep 2014 07:46:29 GMT

(Field1|Field2|Field3) - works unless the values have spaces in between. If spaces are there try like:

=("Value 1"|"Value 2") // enclose within double quotes.

Otherwise try to share your app sample.

Update: Are you talking about multiple fields or field values? For multiple fileds, you have to use multiple triggers; way you tried won't work then.

Re: How to Clear Multiple Fields

ajaykumar1 — Wed, 10 Sep 2014 07:47:04 GMT

Hi,

Can you try other way like select in field put all your 17 fields.

Regards,

Ajay

Re: How to Clear Multiple Fields

Wed, 10 Sep 2014 07:51:37 GMT

Hi Tresesco,

I have put them within [] (Square brackets) But still it does not help

Re: How to Clear Multiple Fields

Wed, 10 Sep 2014 07:53:11 GMT

Hi Ajay,

Adding all 17 within the Select in Field does not seem to be feasible option as there are possiblities that an unexpected 18th selection could be made

Re: Re: How to Clear Multiple Fields

ashfaq_haseeb — Wed, 10 Sep 2014 07:57:47 GMT

Hi,

Have a look at attached file, you can always search in field by passing values in i/p box.

First time pass 20 values, second time pass 3 values.

Hope it helps

Regards

ASHFAQ

Re: How to Clear Multiple Fields

tresB — Wed, 10 Sep 2014 08:04:55 GMT

Note my update statement, multiple fields won't work. You have to use separate triggers for each fields. 'Clear other fields' is for something else. It actually:

"Clears the selections in all the other sheet objects, while maintaining the ones in the current list box."

Re: How to Clear Multiple Fields

israrkhan — Wed, 10 Sep 2014 08:09:33 GMT

what if you use "clear all" first, and than use "select in field" for those three fields...