topic Re: Multiple attributes in single List Box in QlikView

Multiple attributes in single List Box

ashishpalkar — Wed, 10 Feb 2016 20:33:06 GMT

Hi There

Can we have more than one attributes in single list box.

e.g I have 4 columns in database

Player, Rank , State, City

I want to create one list box for all above attributes

Thanks in advance,

Re: Multiple attributes in single List Box

sunny_talwar — Wed, 10 Feb 2016 20:34:31 GMT

You can concatenate them in the script and create a Link table to do this.

Re: Multiple attributes in single List Box

Anonymous — Wed, 10 Feb 2016 20:37:14 GMT

Or maybe use a Multi Box.

Re: Multiple attributes in single List Box

sunny_talwar — Wed, 10 Feb 2016 20:38:45 GMT

May be something along these lines:

Table:

LOAD *,

AutoNumber(Player&'|'&Rank&'|'&State&'|'&City) as UI

Inline [

Player, Rank, State, City

A, 2, NJ, xyz

B, 5, NY, 32

];

LinkTable:

LOAD Player as Field,

Resident Table;

Concatenate(LinkTable)

LOAD Rank as Field,

Resident Table;

Concatenate(LinkTable)

LOAD State as Field,

Resident Table;

Concatenate(LinkTable)

LOAD City as Field,

Resident Table;

Data Model:

Re: Multiple attributes in single List Box

ashishpalkar — Wed, 10 Feb 2016 20:44:02 GMT

Thanks Sunny,, the 4 columns are coming from different tables.. still same solution will work?

Re: Multiple attributes in single List Box

ashishpalkar — Wed, 10 Feb 2016 20:47:04 GMT

Multi Box wont help in this situation.

Re: Multiple attributes in single List Box

Peter_Cammaert — Wed, 10 Feb 2016 21:09:02 GMT

A combination of multiple list boxes is usually called a table box. Try it out.

Best,

Peter

Re: Multiple attributes in single List Box

sunny_talwar — Wed, 10 Feb 2016 21:09:12 GMT

Some modifications will be required (the UI will be associated to the UI from that table and a Link table will be need), but the idea is still going to be same. If you can share a sample of how the data is, we might be able to help better

Re: Multiple attributes in single List Box

ashishpalkar — Wed, 10 Feb 2016 21:22:46 GMT

Hi Sunny

Please find attachment, would like City , State , Name and Rank in one single list box.

Re: Multiple attributes in single List Box

sunny_talwar — Wed, 10 Feb 2016 21:33:53 GMT

Not sure what the idea is, but may be this:

LOAD Name,

Age,

Married

FROM

Book1.xlsx

(ooxml, embedded labels, table is Players);

LOAD City,

Population

FROM

Book1.xlsx

(ooxml, embedded labels, table is City);

LOAD Rank,

Team

FROM

Book1.xlsx

(ooxml, embedded labels, table is Rank);

LOAD State,

Region

FROM

Book1.xlsx

(ooxml, embedded labels, table is State);

ListBox:

LOAD Name as Field,

Name

Resident Players;

Concatenate(ListBox)

LOAD City as Field,

City

Resident City;

Concatenate(ListBox)

LOAD State as Field,

State

Resident State;

Concatenate(ListBox)

LOAD Rank as Field,

Rank

Resident Rank;