topic Re: 2 fields - 1 Listbox in QlikView

2 fields - 1 Listbox

farolito20 — Mon, 18 Mar 2013 16:48:33 GMT

Can I have two fields in one listbox?

For example, my table look like this:

ID, name, InternalCompany, ExternalCompany

1 , Mary , McDonalds, BurgerKing

2 , Jose , BurgerKing, CoffeeStore

3, Lucas, McDonalds, CoffeeStore

I need a Listbox called Company, wich contain McDonald , BurgerKing, CoffeeStore and when I select BurgerKing, the result look like this:

ID, name, InternalCompany, ExternalCompany

1 , Mary , McDonalds, BurgerKing

2 , Jose , BurgerKing, CoffeeStore

Help please!

Re: 2 fields - 1 Listbox

Anonymous — Mon, 18 Mar 2013 17:02:19 GMT

Hi,

You will need to create a Dimension table with all of the necessary values in. In this case a concatenated load of the first table.... try this.... it will then join in ID and use Company as your list box.....

DATA:

LOAD * INLINE [

ID, name, InternalCompany, ExternalCompany

1 , Mary , McDonalds, BurgerKing

2 , Jose , BurgerKing, CoffeeStore

3, Lucas, McDonalds, CoffeeStore

];

DIMENSION:

LOAD ID,

InternalCompany as Company

Resident DATA;

CONCATENATE

LOAD ID,

ExternalCompany as Company

Resident DATA;

Cheers.

ABY.

Re: 2 fields - 1 Listbox

farolito20 — Mon, 18 Mar 2013 17:18:03 GMT

But... How connect my dimension listbox with my fields internalcompany and externalcompany

Sent from my Windows Phone

Re: 2 fields - 1 Listbox

Mon, 18 Mar 2013 17:41:52 GMT

Hi farolito20,

u can write an expression in the listbox as follows:

= ID & ' ' & name & ' ' & InternalCompany & ' ' & ExternalCompany

This should give you the required result

Re: 2 fields - 1 Listbox

Mon, 18 Mar 2013 18:36:15 GMT

You can try changing your data model to :

ID, name, Company, Type

1, Mary , McDonalds, Internal

1, Mary , BurgerKing, External

2, Jose , BurgerKing, Internal

2, Jose , CoffeeStore, External

3, Lucas, McDonalds, Internal

3, Lucas, CoffeeStore, External

Then you can have Company as the field in the list box. Selecting BurgerKing should filter the name field to Mary and Jose.

Re: 2 fields - 1 Listbox

farolito20 — Tue, 19 Mar 2013 17:27:32 GMT

But, how connect my listbox with my table?

Re: 2 fields - 1 Listbox

Tue, 19 Mar 2013 17:36:21 GMT

You change your data model so that it contains Company so the same field will be used for display in the report and for selection.