Discussion board where members can get started with QlikView.
I have 3 tables and I need to display the lines that are not joined.
In the example below I need to display :
Factory, dep_kod, lic_kod, worker_kod
M 1 8 39
Because in table ’ Training_DB’ there is no line for worker =39,lic_kod=8
I have 3 tables:
factory , dep_kod, lic_kod
m 1 7
m 1 8
Factory ,worker_kod, dep_kod
M 39 1
Factory , worker_kod, lic_kod, dep_kod
M 39 7 1
if your trying to achieve this in the chart > Go to >chart properties>Presentation > un- check the suppress null, un-check the suppress zero values
and in the dimension select show all values
first of all thank you for the quick answer.
I still have 2 problems:
1.Iits still showing the values which<>null and I need only the null values.
2.Its' showing null values for every lic_kod even if there is no need.
I think my problem is in the connection between the tables.
Do you have another idea?
Could you post your table view screenshot here.?
In this table I want to see only lickod=9 because it is the only row that dosent have date and is in the correct category.
the only lic_kod that is relevant is 7 and 9
Those are not the null values, they are missing values
Can I display it somehow?