how to display the frequence of the null values

[#1]

hello All,

I have to display  in the graphe the frequence of the  NULL values for a field .But QlikView not allow this.

the Idea is when i load the field , i will transforme the NULL value into an other value like '<NULL>'

exemple : the field is "status"

in the instruction load i will do :

If ( IsNull(status), '<NULL>', status) .  But it's not working. I know that i am not far of the solution

Can someone help me ?

Thanks in advances .

Regards,

Ferhat

[sinanozdemir]

You can try to implement the below function in order to count NULL values:

Count/Sum({1-<Dimension = {"*"}>} Value)

Another approach will be using SET in the load script

SET NullValue ='Unknown/Null';

NULLASVALUE *;

In this way, you are identifying NULL values as Unknown/Null.

Hope this helps

[Anonymous]

try to use len

if (len(status)=0,'<NULL>',Status)

[MarcoWedel · Accepted solution]

one example:

SET NullValue = '<NULL>';
NULLASVALUE status;

table1:
LOAD RecNo() as ID,
    If(Rand()>0.3,Ceil(Rand()*10)) as status
AutoGenerate 30;

hope this helps

regards

Marco

[#5]

yes it's correct , thanks