Null Value in Chart

[#1]

Hi

I have a chart which has axis which include a ' - '.  How can i rename this to be something like Unknown?

Thanks

[Gysbert_Wassenaar]

See this document: NULL handling in QlikView

[PrashantSangle]

Hi,

If it expression

Go to chart->property->Presentation->null Symbol (By default it is -)->write->unknown.

If it is dimension

then write

If(len(trim(dimensionField))>0,DimensionField,Unknown)

or

If(isnull(DimensionField),DimensionField,Unknown)

Regards

[its_anandrjs]

In your load script write a load script like

Eg:-

Raw:

LOAD * Inline

[

Days,Sales

1,234

2,

3,346

4,543

5,

6,543

];

NoConcatenate

Final:

LOAD

Days,

if(Sum(Sales) = 0, 'Unknown' ,sum(Sales)) as Sales //1 Option

If( Len( Trim(Sales) ) > 0,Sales,Unknown) as SalesField // 2 Option

Resident Raw

Group By Days;

DROP Table Raw;

Or

In Expression

If( Len( Trim( Sales))>0,Sales,Unknown)

[#5]

Persentation tab of chart  bottom left change the Null symbol. 

It is highly recommended to change this in the backend with if(isnull(field),'adfasdf',field) AS field  this will enable you to select unknowns

[rupamjyotidas]

in script :

If(len(trim(dimensionField))<1 or isnull(DimensionField),'Unknown',DimensionField) as DimensionField