Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sudhanshu123
New Contributor

Need help in replacing Null on front end in qliksense

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,

2 Replies
thiago_justen
Valued Contributor III

Re: Need help in replacing Null on front end in qliksense

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.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
MVP
MVP

Re: Need help in replacing Null on front end in qliksense

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>

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser