topic Re: null or missing in QlikView

null or missing

raadwiptec — Thu, 18 Feb 2016 11:02:26 GMT

hi ,,

basically my chart is showing for one of the columns as '-' ... but in the presentation tab.. I changed both null symbol and missing symbol to Null and Missing.

But the chart only showed some of them as ;null' and most of them as '-'..

anybody know why is this ? and what '-' corresponds to?

Re: null or missing

sasikanth — Thu, 18 Feb 2016 11:04:57 GMT

May be Your data contains that value?

can share a sample

Re: null or missing

sunny_talwar — Thu, 18 Feb 2016 11:04:59 GMT

May be the data is coming in as '-' instead of null.

Try suppressing the - to null in the script:

PurgeChar(FieldName, '-') as FieldName

Re: null or missing

ashfaq_haseeb — Thu, 18 Feb 2016 11:06:30 GMT

Hi,

This could help you.

https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/30/null-the-invisible-nothing

Regards

ASHFAQ

Re: null or missing

its_anandrjs — Thu, 18 Feb 2016 11:17:10 GMT

Hi,

Try to remove this at the load script by filtering it

Ex:-

Len(FieldName) = 1

Load

If(FieldName = '-', 0 Fieldname)

From Location;

And there are many ways.

Regards,

Anand

Re: null or missing

raadwiptec — Thu, 18 Feb 2016 13:43:38 GMT

hi all I solved it by using a filter in the script where the whitespaces and -..

Re: null or missing

sunny_talwar — Thu, 18 Feb 2016 13:45:00 GMT

Awesome, please close the thread by marking correct and helpful answers if you got what you were looking for