Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

1 Solution

Accepted Solutions
pat_agen
Valued Contributor

Re: Associate the name of columns with a value

hi Annie,

see attached qvw. I've added your radar charts to the initial load.

10 Replies
pat_agen
Valued Contributor

Associate the name of columns with a value

hi,

try loading like this:

loadData:
CROSSTABLE(Skill, value)
LOAD User,
[Skill 1],
[Skill 2],
[Skill 3],
[Skill 4],
[Skill 5],
[Skill 6]
FROM SectorSkills.xls (biff, embedded labels, table is Feuil1$);

SectorSkill:
LOAD Sector,
Skill
FROM SectorSkills.xls (biff, embedded labels, table is Feuil2$);

the crosstable load turns your first set of data into a more manageable form, that is the result is one field called Skill which can then be associtaed with your second dataset.

hope this helps.

Not applicable

Associate the name of columns with a value

hi pat.agen,

I tried your solution and the problem is that User is in the value table and it should not be a value. The aim of this file is to make 2 radas for the 2 sectors with every marks of every skill for each user... I don't know if I'm very clear

Not applicable

Associate the name of columns with a value

annie.lovelace wrote:

hi pat.agen,

I tried your solution and the problem is that User is in the value table and it should not be a value. The aim of this file is to make 2 radas for the 2 sectors with every marks of every skill for each user... I don't know if I'm very clear

not able to understand your problem. Could explains us more in detail?

Not applicable

Re: Associate the name of columns with a value

Maybe it's easier with a draw Here is one of the chart that I need

sector1.bmp

Re: Associate the name of columns with a value

Pat's suggestion of Crosstable looks about right to me. See the attached for how you might create a pivot table mapping users to sectors and skills. If that is not what you want, try to give us a picture of what you want the output to be.

-Rob

http://robwunderlich.com

pat_agen
Valued Contributor

Re: Associate the name of columns with a value

hi Annie,

see attached qvw. I've added your radar charts to the initial load.

Not applicable

Re: Associate the name of columns with a value

Thank you ! I had a mistake in my excel file, that's why it didn't worked first... sorry and thanks

Not applicable

Re: Associate the name of columns with a value

Hi ,

I have a new problem with this table. In my first table, I have one more column with the role. And if I use the same solution you gave me, It doesn't work :

loadData:

CROSSTABLE(Skill, value)

LOAD Role,

           User,

          [Skill 1],

          [Skill 2],

          [Skill 3],

          [Skill 4],

          [Skill 5],

          [Skill 6]

FROM SectorSkills.xls (biff, embedded labels, table is Feuil1$);

SectorSkill:

LOAD Sector,

          Skill

FROM SectorSkills.xls (biff, embedded labels, table is Feuil2$);

How can I add the role and linked it to the user and the value ??

pat_agen
Valued Contributor

Re: Associate the name of columns with a value

hi,

without seeing your changed input data it is hard to reply. Can you post this.

Community Browser