Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

list box

Hi,

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

Thanks..

Tags (1)
7 Replies
Highlighted
Champion III
Champion III

Re: list box

can you explain more?

Highlighted

Re: list box

Try like this

Add an expression like

Field1&'-'&Field2

etc

Highlighted
Champion III
Champion III

Re: list box

Do Concatenation in script  &'-'&

Highlighted
Creator III
Creator III

Re: list box

Hi ,

The fields were

-> Product

-> Category

I need to show with in single list box as,


Product

Category

Thanks..

Highlighted

Re: list box

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


Highlighted

Re: list box

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

Highlighted

Re: list box

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