Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

list box

Hi,

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

Thanks..

7 Replies
Chanty4u
MVP
MVP

can you explain more?

avinashelite

Try like this

Add an expression like

Field1&'-'&Field2

etc

Chanty4u
MVP
MVP

Do Concatenation in script  &'-'&

nareshthavidishetty
Creator III
Creator III
Author

Hi ,

The fields were

-> Product

-> Category

I need to show with in single list box as,


Product

Category

Thanks..

avinashelite

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


MarcoWedel

Hi,

maybe one solution might be:

QlikCommunity_Thread_229933_Pic2.JPG

QlikCommunity_Thread_229933_Pic5.JPG

QlikCommunity_Thread_229933_Pic1.JPG

QlikCommunity_Thread_229933_Pic3.JPG

QlikCommunity_Thread_229933_Pic4.JPG

hope this helps

regards

Marco

MarcoWedel

another solution might be:

QlikCommunity_Thread_229933_Pic6.JPG

QlikCommunity_Thread_229933_Pic7.JPG

QlikCommunity_Thread_229933_Pic8.JPG

QlikCommunity_Thread_229933_Pic9.JPG

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