Project activities and competence matrix

Mon, 04 Feb 2013 09:59:36 GMT

Hello!

I am experiencing a re-occuring problem when you have to reference two fields in tables (synthetic keys occur).

My application in QV11 is a visualisation of employee (name), planned project activities and relevant competence. Planned project activities are stored in table Beläggning and a competence matrix is stored in table Kompetensmatris (see picture below).

Project activities and competences are identical and labelled Aktivitetsbeskrivning and is the link between tables Beläggning and Kompetensmatris. In order not to get a synthetic key, name has different labels in tables Beläggning and Kompetensmatris ("Namn" and "Namn_kompetens"). Now I want to select a certain project activity and then display what employees that have necessary competence to perform it. That works fine. But if I select a certain employee and want to show all his/hers competences, only competences that have a planned project activity in table Beläggning show. I understand why, becuase the two selections refers to different names, "Namn" and "Namn_kompetens". I need to have name labelled the same way in both tables but then I get a synthetic key.

I have tried to define a unique key that should link tables Beläggning and Kompetensmatris instead but I can still not select an employee and display all competences.

Is there a clever solution for such a problem?

Thanks in advance.

Jens

Re: Project activities and competence matrix

Tue, 05 Feb 2013 10:10:40 GMT

Hello!

I found a solution to this by joining data from table "Kompetensmatris" into table "Beläggning" as the last operation in the script.

Join (Beläggning) Load
Namn_kompetens as Namn,
Aktivitetsbeskrivning
Resident Kompetensmatris;

Then all "Project activities" and "Competences" get represented in table "Beläggning".

topic Re: Project activities and competence matrix in QlikView

Project activities and competence matrix

Re: Project activities and competence matrix