Sales with text and Number - Dual

[renjithpl]

Hi All,

what are the effective ways to set Text to the Sales Field ?

Eg. if(Isnull(Sales), 'N/A', Sales) as Dual_Sales

and in the front end chart,

like below

ID	Sales
1	N/A
2	100
3	200

THanks

Renji

[swuehl]

Maybe use NULLASVALUE and NULLVALUE as in

NullValue ‒ QlikView

[lgutierrez]

Hi Renjit,

As an advice we recomend try to filter the data since de extraction process, since the source data. any way many qlik objects bring with the option "Include Null values" unckeck this option.

regards.