topic Re: How to use field with multiple values in QlikView

How to use field with multiple values

Anonymous — Mon, 05 Nov 2012 20:25:59 GMT

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 — Mon, 05 Nov 2012 20:39:03 GMT

Try like this

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

Hope it helps

Anonymous — Mon, 05 Nov 2012 20:51:49 GMT

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 — Mon, 05 Nov 2012 21:00:17 GMT

Please use count(distinct roleid)