topic Re: excluding listbox selections in current selections box? in QlikView

excluding listbox selections in current selections box?

Anonymous — Fri, 04 Jul 2014 16:03:56 GMT

I have 3 list boxes named LB1, LB2 and LB3.Current Selections Box should not show the selected values from LB3.This is my requirement.How can do that?

Thanks in Advance

Re: excluding listbox selections in current selections box?

Colin-Albert — Fri, 04 Jul 2014 16:08:55 GMT

If you tag a field as $hidden in the load script then the field selection will not display in the current selection box.
The selections are still active in the data though.

TAG FIELD [Your Field Name] with '$hidden' ;

In your load script, add the following (assuming the field displayed in listbox LB3 is named LB3

TAG FIELD LB3 with '$hidden' ;

Re: excluding listbox selections in current selections box?

maxgro — Fri, 04 Jul 2014 16:52:01 GMT

you can use hideprefix or hidesuffix to hide the fields starting with the char you want

set HidePrefix='_' ;

the field names beginning with an underscore will not be shown in the current selections

Re: excluding listbox selections in current selections box?

Anonymous — Sat, 05 Jul 2014 06:21:38 GMT

Thanks Massimo...

Re: excluding listbox selections in current selections box?

Anonymous — Sat, 05 Jul 2014 06:22:00 GMT

Thanks Colin..

Re: excluding listbox selections in current selections box?

kmswetha — Mon, 23 Feb 2015 15:49:50 GMT

Hi Colin,

TAG FIELD LB3 with '$hidden' in my load script it is not working.

pls suggest