Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field which has multiple linking keys
Executive name Role id
Mike 2,3,45,67
Sam 2,5,64,78
Role ids is linked to Roles Table where I come to know the roles
Role id Role Name
1 Sales
2 HR
3 Operations
etc
How should I link role id?
Will it take the values a separate numbers or as a string?
Thanks
Hi
Try like this
Load subfield(Roleid,',') as Roleid, ExecutiveName from table1;
Hope it helps
Hi
Try like this
Load subfield(Roleid,',') as Roleid, ExecutiveName from table1;
Hope it helps
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?
HI
Please use count(distinct roleid)