Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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
@Mahdi share some sample data
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.
@Mahdi would you be able to share sample data in excel ?
Sure, Here it is.
@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
Hope this works
@Mahdi see the attached
Thank you for your time, but I'm unable to open the file attached, Can you please help me find a 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