topic Re: Create hierarchy based on column labels in QlikView

Create hierarchy based on column labels

Tue, 02 Jul 2013 11:16:21 GMT

Hi All,

I have a list of people and their associated skills. These skills need to be categorised as either technical skills, soft skills or process specific skills.

The data has been provided to me in the format below:

Name	Skill 1	Skill 2	Skill 3	Skill 4	Skill 5	Skill 6	Skill 7	Skill 8	Skill 9
Joe Bloggs
Jane Bloggs

For example how can I group Skills 1-3 as 'Technical', Skill 4 & 9 as 'Soft-Skills' and Skills 5 - 8 as 'Process skills'?

Many thanks,

Re: Create hierarchy based on column labels

Gysbert_Wassenaar — Tue, 02 Jul 2013 11:24:20 GMT

My recommendation would be to use the Crosstable function to transform the data to a table with the fields Name and Skill:

Skills:

Crosstable(Skill, Skillname)

load * from ...somewhere...;

That will give you a table like:

Name, Skill, Skillname

Joe Bloggs, Skill 1, abc

Joe Bloggs, Skill 2, cde

...etc

You can then create a skill groups table to link groups to skills:

Groups:

load * inline [

Skillgroup, Skill

Technical, Skill 1

Technical, Skill 2

Technical, Skill 3

Soft, Skill 4

Soft, Skill 9

Proces, Skill 5

...etc

];