Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
razyorazyo
New Contributor II

lines which are not collabrated

Hi all,

I have a question, how can I show lines that are exist in one table and do not exist on the other table.

example:

first table:

   

factoryworker idlic kod
111
112
121

second table:

 

 

   

factorylic iddep_kod
111
121


third table:

   

factorydep_kodworker id
111
112



I want to create a table which will present the next data :

factorydep_kodworker idlic kod
112

2

  worker_id 2 is not connected to LIC__KOD 2 .

worker_id 2 is connected to dep 1 which is connected to lic cod 2.

thank you