Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Associate the name of columns with a value

Hi !

I have an excel file with this 2 sheets. I want to associate the skills with their sector. How can I do that ?

UserSkill 1Skill 2Skill 3Skill 4Skill 5Skill 6
user 1024230
user 2015241
user 3132102

SectorSkill
Sector 1skill 1
Sector 1skill 2
Sector 1skill 3
Sector 2skill 4
Sector 2skill 5
Sector 2skill 6

Thank you 😃

Annie

10 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Look at crosstable in the ref guide or help. You need to add the numeric parm that indicates you have two columns.

Rob