Displaying the null values

[razyorazyo]

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

[avinashelite]

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]

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?

[tamilarasu]

Could you post your table view screenshot here.?

[razyorazyo]

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

[avinashelite]

Those are not the null values, they are missing values

[razyorazyo]

OK.

Can I display it somehow?