null or missing

[raadwiptec]

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?

[sasikanth]

May be Your data contains that value?

can share a sample

[sunny_talwar]

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

Try suppressing the - to null in the script:

PurgeChar(FieldName, '-') as FieldName

[ashfaq_haseeb]

Hi,

This could help you.

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

Regards

ASHFAQ

[its_anandrjs]

Hi,

Try to remove this at the load script by filtering it

Ex:-

Len(FieldName) = 1

Or

Load

*,

If(FieldName = '-', 0 Fieldname)

From Location;

And there are many ways.

Regards,

Anand

[raadwiptec · Accepted solution]

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

[sunny_talwar]

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