topic exclude values from default selection in QlikView

exclude values from default selection

Tue, 05 Jul 2011 10:50:02 GMT

Hello All,

I know how to select a value by default from a field in a filter. I have used the select in field trigger which works quite good for me.

Now another requirements came across me, which is to include all values and exculde 'Other' by default from a field in a filter. Can some one tell me, how can i exclude a value by default from a filter field in a sheet.

What i mean to say is select All values in a field except 'Other' by default. The field name is Plant

Arif

Re: exclude values from default selection

IAMDV — Tue, 05 Jul 2011 11:02:39 GMT

Arif - You can use simple IF statement. Something like this...

=IF(FieldName<> 'Other', FieldName)

You can use the same in ListBox expression to hide the 'Other' option.

I hope this helps!

Cheers - DV

exclude values from default selection

kaushiknsolanki — Tue, 05 Jul 2011 11:03:30 GMT

Hi,

Try this.

Add first Action to button as Selection in field Field name and Value as "Other"

then

Second Action as Select Excluded with same field name

Regards,

Kaushik Solanki