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: 
Anonymous
Not applicable

Combine 2 columns in a LIST Box that is not linked to each other

Hi,

I have 2 tables Security and User Details

These 2 tables are not linked together.

But in List box i want Username from Security and User Description from User Details tables should be displayed.

Ex:

Security Table

Username

qlik10

qlik20

Qlik30

 

User Details

Userid  User description

Qlik10  Employee1

Qlik20 Employee 2

Qlik30 Employee3

Qlik40 Employee4

 

In the List Box it should display

Qlik10 - Employee1

Qlik20 - Employee2

Qlik30 - Employee3

 

User details will have more records than Security Table and more user name than security table.

Please help.

Thanks

DevQlik

 

Labels (1)
1 Solution

Accepted Solutions
OmarBenSalem

Create ur list box as follow:

=if(Upper( Username) = Upper(Userid),  Userid&'-'& [User description])

 

Result:

Capture.PNG

Capture.PNG

View solution in original post

4 Replies
OmarBenSalem

Would it be a solution to link the 2 tables in the script? or u want a front end solution?

Anonymous
Not applicable
Author

Datamodel restricts Joining these 2 tables and its just for showing.

Front end solution please.

OmarBenSalem

Create ur list box as follow:

=if(Upper( Username) = Upper(Userid),  Userid&'-'& [User description])

 

Result:

Capture.PNG

Capture.PNG

Anonymous
Not applicable
Author

Wow it works.. i was trying set analysis and everything but none worked.

Thanks you, its a shame why simple IF statement come to my mind.