topic Need help in replacing Null on front end in qliksense in App Development

Need help in replacing Null on front end in qliksense

sudhanshu123 — Tue, 30 Jan 2018 05:07:58 GMT

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_ — Tue, 30 Jan 2018 09:40:25 GMT

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 — Tue, 30 Jan 2018 09:49:26 GMT

Use this to replace nulls with 0

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

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