Qlik Community

Qlik Sense App Development

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

ilanbaruch
Contributor

qliksense zero values

hi all,

i have a table with 5 expressions and month as a dimension,

first month is empty so all expressions shows zero or null.

unchecked show nulls under moth dimension

unchecked show zero values under add-ons data handling


any ideas ?zero values.jpg

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: qliksense zero values

For all measures try, Alt(Expression,0)

6 Replies
shraddha_g
Honored Contributor III

Re: qliksense zero values

There might be a case that these are not zero values but like 0.234545 in decimal format.

try keeping number format as auto and then see what are the values it is giving at place of 0.

ilanbaruch
Contributor

Re: qliksense zero values

Thank you Shraddha, changed all number formatting to Auto, i  still see zero values and nulls..zero values 1.jpg

shraddha_g
Honored Contributor III

Re: qliksense zero values

can you share sample app?

priyasawant
Contributor

Re: qliksense zero values

Hi Please check the numbers in measures Untitled.png

shraddha_g
Honored Contributor III

Re: qliksense zero values

For all measures try, Alt(Expression,0)

shraddha_g
Honored Contributor III

Re: qliksense zero values

You can also try

if(expression >0, Expression) for all.

Not so optimal solution but I guess it will work.