topic Re: List box value filtering in QlikView

List box value filtering

raju_salmon — Wed, 09 Sep 2015 11:20:45 GMT

Dear Experts,

I have a list box contain some names, whereas i want to show only few selected names.

Ex:

Name

ABC

XYZ

STR

VWX

SDR

I want to show display a list box without XYZ and SDR, is there any way like writing a expression on sort tab or any other way.

Please suggest.

Regards,

Raju Salmon

Wed, 09 Sep 2015 11:23:12 GMT

u can write an expression in the list box

if(name<>'XYZ',if(name<>'SDR'),name)

Thanks and Regards

Khushboo

Wed, 09 Sep 2015 11:24:50 GMT

For writing an expression u can go to list box properties,

on general tab field----> expression --bottom most value of list box

maxgro — Wed, 09 Sep 2015 11:24:53 GMT

make a listbox with the express (at the bottom)

=if(not Match(Name,'XYZ','SDR'), Name)

Wed, 09 Sep 2015 11:25:55 GMT

use the follwing expression in List box as Expression

=if(not Match(FieldName,'Value1', 'Val2'), FieldName)

qlikmsg4u — Wed, 09 Sep 2015 11:25:57 GMT

Use this

=If(not Match(Name,'XYZ','SDR'),Name)