Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Project activities and competence matrix

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).

ScreenShot003.bmp

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

1 Solution

Accepted Solutions
Not applicable

Re: Project activities and competence matrix

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".

1 Reply
Not applicable

Re: Project activities and competence matrix

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".

Community Browser