topic Re: listbox expression in QlikView

listbox expression

sivarajs — Mon, 15 Jun 2015 07:20:13 GMT

Hi,

I am trying to show few columns in listbox based on product code as key column.I am using maxstring in expression to fetch values. Because of this keyword am getting only one row out of 10 values to a single product code.Is there any keyword or any ways where i can show all the values in listbox.

Also i need to select only one row at a time.

Regards,

Sivaraj

Re: listbox expression

Gysbert_Wassenaar — Mon, 15 Jun 2015 07:35:04 GMT

Why do you need those columns in a listbox? Can't you use a Table Box object instead? That way you won't need to mess around with expressions.

Re: listbox expression

sivarajs — Mon, 15 Jun 2015 09:21:04 GMT

As i mentioned, the user need to select only one row at a time. In listbox we have check option, so i used it.

Re: listbox expression

sivarajs — Mon, 15 Jun 2015 11:40:57 GMT

gysbert, anyway to achieve this?

Re: listbox expression

Gysbert_Wassenaar — Mon, 15 Jun 2015 11:53:24 GMT

Nope. Use a listbox for selecting, use a table box for showing the other columns.

Re: listbox expression

tresB — Mon, 15 Jun 2015 12:05:57 GMT

Kind of work around(with obvious limitations) could be like attached sample qvw?

Re: listbox expression

Anonymous — Thu, 20 Aug 2015 18:04:08 GMT

Hello,

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

Re: listbox expression

Gysbert_Wassenaar — Fri, 21 Aug 2015 05:22:21 GMT

You created the expression on the Expressions tab. Now create it instead after selecting <Expression> in the field selector on the General tab.

Re: listbox expression

Anonymous — Mon, 24 Aug 2015 20:58:53 GMT

Thank you so much.

Regards,

Paul