Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Contributor II
Contributor II

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

Front end solution please.

Highlighted
Partner
Partner

Create ur list box as follow:

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

 

Result:

Capture.PNG

Capture.PNG

View solution in original post

Highlighted
Contributor II
Contributor II

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.