topic Re: Null Value in Chart in QlikView

Null Value in Chart

Fri, 30 May 2014 12:52:12 GMT

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

Thanks

Re: Null Value in Chart

Gysbert_Wassenaar — Fri, 30 May 2014 12:57:34 GMT

See this document: NULL handling in QlikView

Re: Null Value in Chart

PrashantSangle — Fri, 30 May 2014 13:04:16 GMT

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)

If(isnull(DimensionField),DimensionField,Unknown)

Regards

Re: Null Value in Chart

its_anandrjs — Fri, 30 May 2014 13:26:02 GMT

In your load script write a load script like

Eg:-

Raw:

LOAD * Inline

[

Days,Sales

1,234

3,346

4,543

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;

In Expression

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

Re: Null Value in Chart

Fri, 30 May 2014 13:41:50 GMT

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

Re: Null Value in Chart

rupamjyotidas — Fri, 07 Oct 2016 01:09:47 GMT

in script :

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