topic Re: list box in QlikView

list box

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to show two different fields of same table in an single listbox.

Thanks..

Re: list box

Chanty4u — Mon, 22 Aug 2016 12:26:14 GMT

can you explain more?

Re: list box

avinashelite — Mon, 22 Aug 2016 12:26:23 GMT

Try like this

Add an expression like

Field1&'-'&Field2

etc

Re: list box

Chanty4u — Mon, 22 Aug 2016 12:29:26 GMT

Do Concatenation in script &'-'&

Re: list box

nareshthavidishetty — Mon, 22 Aug 2016 12:33:35 GMT

Hi ,

The fields were

-> Product

-> Category

I need to show with in single list box as,

Product

Re: list box

avinashelite — Mon, 22 Aug 2016 12:40:47 GMT

in front end .

Go to Listbox >general> select the expression option in the field selection > and add this expression

Product&','&Category

if you need to link all the Category to respective Product group then try like this

Temp:

LOAD Product,

Category

from table ;

LOAD Product,

concat(Category,',') as P_category

resident

Temp

Group By

Product;

try this in the front end

Product&','&P_category

Re: list box

MarcoWedel — Mon, 22 Aug 2016 22:03:49 GMT

Hi,

maybe one solution might be:

hope this helps

regards

Marco

Re: list box

MarcoWedel — Mon, 22 Aug 2016 22:34:57 GMT

another solution might be:

table1:

LOAD RecNo() as ID, *

INLINE [

Product, Category

product11, category1

product12, category1

product13, category1

product21, category2

product22, category2

product31, category3

product32, category3

product33, category3

product34, category3

];

tabProdCat:

CrossTable (Type, ProductCategory)

LOAD * Resident table1;

hope this helps

regards

Marco