topic Re: qliksense zero values in App Development

qliksense zero values

ilanbaruch — Mon, 14 Nov 2016 09:17:59 GMT

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 — Mon, 14 Nov 2016 09:25:07 GMT

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 — Mon, 14 Nov 2016 10:07:45 GMT

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

shraddha_g — Mon, 14 Nov 2016 10:09:22 GMT

can you share sample app?

priyasawant — Mon, 14 Nov 2016 10:37:32 GMT

Hi Please check the numbers in measures

shraddha_g — Mon, 14 Nov 2016 10:41:15 GMT

For all measures try, Alt(Expression,0)

shraddha_g — Mon, 14 Nov 2016 12:26:20 GMT

You can also try

if(expression >0, Expression) for all.

Not so optimal solution but I guess it will work.