Handel nulls in qlikview

[#1]

Hello,

I'm facing an issue with nulls in the report.

For example: when we hit a query to database, no records are fetched. So for the same query(expression) in in straight table we are able to see '0's for all dimensions with no records. Our requirement is to show, where their is no records we need to display as null in the straight table.

Could any one can suggest solution to handle nulls in the above scenario.

Thanks in advance.

[sunilkumarqv]

Try this

SET NullValue='<NULL>';

SET NullDisplay='Null';

[sasiparupudi1]

You could use an if condition may be?

=if(YourField=0,Null(),YourField)

[tresesco]

Go through this : NULL handling in QlikView , hopefully would solve many such issues you might fetch in future developments as well.

[qv_testing]

Try this

NullAsValue FieldName;

Set NullValue='NULL';

or

If(FieldName=0, 'Null', FieldName)

[#6]

I tried above 2 options, but not able to get solution.

If the record has not entered in db, for those we need to show as null instead of 0. Qlikview by default it is displaying as 0.

[qlikviewwizard]

Hi

Use like this:

=if(Field=0,Null(),Field)