topic Re: Displaying the null values in QlikView

Displaying the null values

razyorazyo — Mon, 12 Oct 2015 13:34:28 GMT

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 — Mon, 12 Oct 2015 13:55:54 GMT

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 — Tue, 13 Oct 2015 06:29:37 GMT

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 — Tue, 13 Oct 2015 06:40:22 GMT

Could you post your table view screenshot here.?

razyorazyo — Tue, 13 Oct 2015 07:01:58 GMT

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 — Tue, 13 Oct 2015 08:01:05 GMT

Those are not the null values, they are missing values

razyorazyo — Tue, 13 Oct 2015 08:42:17 GMT

OK.

Can I display it somehow?