Need help in replacing Null on front end in qliksense

[sudhanshu123]

Hi,

Need help in replacing Null on front end in qliksense.

we have pivot table in which we are getting nulls and we need to replace null with zero.

Pivot table have two dimension and one measure.

We need to know if we can replace '-' symbol with 0 ,by changing it somewhere in backend.

Thanks,

[Thiago_Justen_]

You should try something like that:

If(len(trim(YOUR_DIMENSION))= 0 or YOUR_DIMENSION='NULL' or YOUR_DIMENSION='-', 'VALUE_TO_REPLACE',YOUR_DIMENSION )

This could be used in backend or frontend.

[jonathandienst]

Use this to replace nulls with 0

=Alt(<your expression>, 0)  // assumes <your expression> is numeric

or

=If(Len(<your expression>) = 0, 0, <your expression>)  // will handle non-numeric <your expression>