Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hi all I solved it by using a filter in the script where the whitespaces and -..
May be Your data contains that value?
can share a sample
May be the data is coming in as '-' instead of null.
Try suppressing the - to null in the script:
PurgeChar(FieldName, '-') as FieldName
Hi,
This could help you.
https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/30/null-the-invisible-nothing
Regards
ASHFAQ
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
hi all I solved it by using a filter in the script where the whitespaces and -..
Awesome, please close the thread by marking correct and helpful answers if you got what you were looking for