Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Null Value in Chart

Hi

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

Thanks

5 Replies
MVP & Luminary
MVP & Luminary

Re: Null Value in Chart

See this document: NULL handling in QlikView


talk is cheap, supply exceeds demand

Re: Null Value in Chart

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

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Null Value in Chart

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)

Not applicable

Re: Null Value in Chart

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
Valued Contributor

Re: Null Value in Chart

in script :

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