Discussion Board for collaboration on QlikView Scripting.
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.
Userid User description
Qlik20 Employee 2
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.
Create ur list box as follow:
=if(Upper( Username) = Upper(Userid), Userid&'-'& [User description])
View solution in original post
Would it be a solution to link the 2 tables in the script? or u want a front end solution?
Datamodel restricts Joining these 2 tables and its just for showing.
Front end solution please.
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.