Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
razyorazyo
New Contributor II

Displaying the null values

 

Hi everyone

 

 

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:

 

departmment_licens

 

factory  , dep_kod, lic_kod

 

m            1                              7

 

m            1                              8

 

 

WORKERS_DEPARTMENTS

 

Factory ,worker_kod, dep_kod

 

M            39                           1

 

 

Training_DB

 

Factory , worker_kod, lic_kod, dep_kod

 

M                            39           7              1

 

 

 

Thank you

 

 

Raz

 

6 Replies

Re: Displaying the null values

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

razyorazyo
New Contributor II

Re: Displaying the null values

Hi Avinash,

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?

Re: Displaying the null values

Could you post your table view screenshot here.?

razyorazyo
New Contributor II

Re: Displaying the null values

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

Re: Displaying the null values

Those are not the null values, they are missing values

razyorazyo
New Contributor II

Re: Displaying the null values

OK.

Can I display it somehow?