How to use field with multiple values

[Anonymous]

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

[MayilVahanan · Accepted solution]

Hi

Try like this

Load subfield(Roleid,',') as Roleid, ExecutiveName from table1;

Hope it helps

[Anonymous]

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?

[MayilVahanan]

HI

Please use count(distinct roleid)