topic Re: create a list based on multiple column values in QlikView

create a list based on multiple column values

Wed, 20 Apr 2016 05:14:41 GMT

Hi, I have a requirement to create a list based on multiple column values

Eg:

I have this data

Now, I need a dropdown with values abc,def,ghi,jkl,mno,xyz.

If I select any value in the dropdown I need to get all the rows that have the value in any of the columns-1,2,3

i.e, if I select abc in the dropdown, I need to get 1,2,4,5 rows.

if I select def, I need to get the rows 1,2,3

sunny_talwar — Wed, 20 Apr 2016 11:37:17 GMT

Try this:

Table:

LOAD Column1,

Column2,

Column3,

RowNo

FROM

[https://community.qlik.com/thread/213805]

(html, codepage is 1252, embedded labels, table is @1);

LinkTable:

LOAD Column1 as ColumnSelection,

RowNo

Resident Table;

Concatenate (LinkTable)

LOAD Column2 as ColumnSelection,

RowNo

Resident Table;

Concatenate (LinkTable)

LOAD Column3 as ColumnSelection,

RowNo

Resident Table;

Wed, 20 Apr 2016 12:19:19 GMT

Thanks