Discussion Board for collaboration related to QlikView App Development.
I have a field which has multiple linking keys
Executive name Role id
Role ids is linked to Roles Table where I come to know the roles
Role id Role Name
How should I link role id?
Will it take the values a separate numbers or as a string?
Try like this
Load subfield(Roleid,',') as Roleid, ExecutiveName from table1;
Hope it helps
View solution in original post
Thanks a lot.
It helped me solve one of my problem.
I have to use distinct when counting right?
I was also looking for answers to some other questions. But is it because I put it in "New to Qlikview" so no one is replying?
Please use count(distinct roleid)