Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create ur list box as follow:
=if(Upper( Username) = Upper(Userid), Userid&'-'& [User description])
Result:
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.
Create ur list box as follow:
=if(Upper( Username) = Upper(Userid), Userid&'-'& [User description])
Result:
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.