topic Re: Join in Qlik in QlikView

Join in Qlik

master_student — Thu, 03 Nov 2016 13:51:30 GMT

Hello community,

I need your help

I have two tables

employees // contains all the persons ID of all employees

person_id

division

pointages // this table contains the persons id of pepole that did the badging

person_id

date_deb //contains the start time when the employe do the badging;

I need to dislay a table that contains all persons id even if they didn't did the badging

person_id date_deb

2 15/02 12:33:12

8 -

6 -

I tried all types of join but it didn't work, only persons id with date deb are displayed :

Re: Join in Qlik

Anonymous — Thu, 03 Nov 2016 13:59:21 GMT

HI,

First of all, you don't need to make any join, you just need to have the same field name (person_id) in the two tables when you load the datas.

Then make a simple table - not a graphic but a table (Zone table) - and add the fields person_id and date_deb.

With this you shoulod be able to get all person_id with their date_deb if it exists or a blank field if there is no date_deb for the person_id.

Re: Join in Qlik

master_student — Thu, 03 Nov 2016 14:12:10 GMT

hello, I did as you mentioned

Here's my model :

whene i display the data zone table :

there are grey fileds in the person ID filter but i can't find theme whene I click on any grey value

Re: Join in Qlik

Anonymous — Thu, 03 Nov 2016 14:37:05 GMT

Salut,

Au vue de ton model, je suppose que tu parles français 😉

Les champs grisés sont surement dus à une sélection active à laquelle ne sont pas associés les PERSON_ID (une année ou un mois peut-être)

De plus, il me semble que les PERSON_ID et les DATE_DEB proviennent d'une seule et même table non?

Re: Join in Qlik

master_student — Thu, 03 Nov 2016 15:13:35 GMT

Salut

J'ai juste sélectionné la date, normalement tous les employés doivent faire le badging pour une journée bien précise. s'ils n'ont pas fait le pointage, leurs noms doivent apparaîtrent avec date_deb vides

ci dessous mes sélections :