topic Handel nulls in qlikview in QlikView

Handel nulls in qlikview

Wed, 29 Jul 2015 06:50:22 GMT

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.

Re: Handel nulls in qlikview

sunilkumarqv — Wed, 29 Jul 2015 06:56:21 GMT

Try this

SET NullValue='<NULL>';

SET NullDisplay='Null';

Re: Handel nulls in qlikview

sasiparupudi1 — Wed, 29 Jul 2015 06:57:23 GMT

You could use an if condition may be?

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

Re: Handel nulls in qlikview

tresB — Wed, 29 Jul 2015 07:01:27 GMT

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

Re: Handel nulls in qlikview

Nagaraju_KCS — Wed, 29 Jul 2015 07:02:51 GMT

Try this

NullAsValue FieldName;

Set NullValue='NULL';

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

Re: Handel nulls in qlikview

Wed, 29 Jul 2015 07:04:22 GMT

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.

Re: Handel nulls in qlikview

qlikviewwizard — Wed, 29 Jul 2015 07:05:53 GMT

Use like this:

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