Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
saurabh_pandit
Creator
Creator

How to use field with multiple values

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

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

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

Hope it helps

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

Hi

Try like this

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

Hope it helps

Thanks & Regards,
Mayil Vahanan R

View solution in original post

saurabh_pandit
Creator
Creator
Author

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)

Thanks & Regards,
Mayil Vahanan R