Need Help ASAP !!!

[Mahdi]

Hello, 

I was wondering if it is possible to create a Skill Matrix with qlikView. 

Something similar to this : 

If yes, how ? 

Thank you for your help.

[Kushal_Chawda]

@Mahdi  share some sample data

[Mahdi]

I have these 3 tables : nom_technologies : refers to the skill 

nom_complet : refers to the employee  and nom_niveau_couleur refers to the level composed of 4 colours. 

I want to create a matrix in order to specify the level of each employee for each skill. 

Thank you.

[Kushal_Chawda]

@Mahdi  would you be able to share sample data in excel ?

[Mahdi]

Sure, Here it is.

[Kushal_Chawda]

@Mahdi  your data seems incomplete because there is no link between employees, technologies and level. Basically each employee should have details of their technology and level

[Mahdi]

Hope this works 

[Kushal_Chawda]

@Mahdi  see the attached

[Mahdi]

Thank you for your time, but I'm unable to open the file attached, Can you please help me find a solution.

[Kushal_Chawda · Accepted solution]

@Mahdi  try below

Data:
LOAD id_consultant,
id_geographie,
id_formation,
id_key,
Pick(id_niveau_couleur, rgb(255,0,0),rgb(255,128,0),rgb(255,255,0),rgb(0,255,0)) as level_color,
id_competence,
id_appetence,
id_niveau_couleur,
date_entree
FROM
[C:\DATA (1).xlsx]
(ooxml, embedded labels, table is RH);

assuming  that id_competence is your skills and id_consultant is your employee . You can create pivot table with below dimensions and  measure

Dimension:

id_competence

id_consultant (drag it to horizontal)

Measure:

=Only(id_niveau_couleur) 

Assuming id_niveau_couleur is the level with color . 1 means lowest. You can change it according to your definition of color (refer to load statement highlighted above)

In measure properties, for Background color and Text color, call level_color