topic Re: Need Help ASAP !!! in Search the Community

Need Help ASAP !!!

Mahdi — Mon, 23 Aug 2021 14:29:48 GMT

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.

Re: Need Help ASAP !!!

Kushal_Chawda — Mon, 23 Aug 2021 14:53:42 GMT

@Mahdi share some sample data

Re: Need Help ASAP !!!

Mahdi — Mon, 23 Aug 2021 14:58:29 GMT

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.

Re: Need Help ASAP !!!

Kushal_Chawda — Mon, 23 Aug 2021 15:06:30 GMT

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

Re: Need Help ASAP !!!

Mahdi — Mon, 23 Aug 2021 15:09:38 GMT

Sure, Here it is.

Re: Need Help ASAP !!!

Kushal_Chawda — Mon, 23 Aug 2021 15:13:23 GMT

@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

Re: Need Help ASAP !!!

Mahdi — Mon, 23 Aug 2021 15:47:32 GMT

Hope this works

Re: Need Help ASAP !!!

Kushal_Chawda — Mon, 23 Aug 2021 16:46:02 GMT

@Mahdi see the attached

Re: Need Help ASAP !!!

Mahdi — Tue, 24 Aug 2021 08:12:36 GMT

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

Re: Need Help ASAP !!!

Kushal_Chawda — Tue, 24 Aug 2021 10:43:33 GMT

@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

Re: Need Help ASAP !!!

Mahdi — Tue, 24 Aug 2021 14:04:16 GMT

Thank you very much, It actually worked but as you can see, It doesn't show all the rows.