Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

create a list based on multiple column values

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

Eg:

I have this data

Column1Column2Column3RowNo
abcghidef1
jklabcdef2
jkldefxyz3
ghijklabc4
mnoabcjkl5

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

1 Solution

Accepted Solutions
sunny_talwar

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;


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

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;


Capture.PNG

Not applicable
Author

Thanks