topic Message for null data in QlikView

Message for null data

devans_1 — Wed, 19 Jun 2013 09:37:50 GMT

Hi All,

In a Chart, on the presentation tab there is an input for 'Null Symbol'. Can this be populated with a variable - ie $(Error Msg) ? I can't get it to work for me. It just displays %(Error Msg) rather than the value of the variable.

Re: Message for null data

sujeetsingh — Wed, 19 Jun 2013 09:43:57 GMT

Can you give the sample ?

There is no option for Expression !!

But yes one can do at expression level.

Re: Message for null data

flipside — Wed, 19 Jun 2013 09:55:46 GMT

No you can't do it in the Null Symbol box, so as Ek tha Tiger says, do it at expression level. The easiest way is to create a second expression after your actual expression with this ...

=if(IsNull([ColA]),'Error Message',[ColA])

... where [ColA] is the label for your actual expression. You can then hide the actual expression if you wish.

flipside