topic Re: Show Only matched values in List Box using Expression in QlikView

Show Only matched values in List Box using Expression

Anonymous — Thu, 20 Aug 2015 17:37:31 GMT

Hello Experts,

I have loaded thousand of records using Load script. I created a List Box and it shows all the thousand distinct values as below screen

Now i want filter and display only 6511001,6511002,7511001 and 7511006.

I went properties of list box and wrote the expression as below

I see the matching values besides the value and rest all not matched has '-'. I want to see only match values in the list box.

Please see below the values i see as :

I want to see only Matching value and rest all should be hidden.

Appreciate your help.

Regards,

Paul

Thu, 20 Aug 2015 18:24:01 GMT

Create the Listbox with Expression on the general tab. The Expression is last after all fields.

Anonymous — Thu, 20 Aug 2015 18:28:56 GMT

Thank you Dathu. It is very helpful.

Appreciate your help.

Regards,

Paul

Anonymous — Thu, 20 Aug 2015 18:37:21 GMT

Thank you Dattu

MarcoWedel — Thu, 20 Aug 2015 18:38:05 GMT

Don't use the expression tab of the listbox properties but the expression entry in the fields dropdown box.

Regards

Marco

Anonymous — Thu, 20 Aug 2015 20:30:21 GMT

Thank you Marco.

Regards,

Paul