qliksense zero values

[ilanbaruch]

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 ?

[shraddha_g]

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]

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

[shraddha_g]

can you share sample app?

[priyasawant]

Hi Please check the numbers in measures

[shraddha_g · Accepted solution]

For all measures try, Alt(Expression,0)

[shraddha_g]

You can also try

if(expression >0, Expression) for all.

Not so optimal solution but I guess it will work.