Discussion Board for collaboration related to QlikView App Development.
I have a chart which has axis which include a ' - '. How can i rename this to be something like Unknown?
See this document: NULL handling in QlikView
If it expression
Go to chart->property->Presentation->null Symbol (By default it is -)->write->unknown.
If it is dimension
In your load script write a load script like
LOAD * Inline
if(Sum(Sales) = 0, 'Unknown' ,sum(Sales)) as Sales //1 Option
If( Len( Trim(Sales) ) > 0,Sales,Unknown) as SalesField // 2 Option
Group By Days;
DROP Table Raw;
If( Len( Trim( Sales))>0,Sales,Unknown)
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
in script :
If(len(trim(dimensionField))<1 or isnull(DimensionField),'Unknown',DimensionField) as DimensionField