Discussion Board for collaboration related to QlikView App Development.
I'm trying express a mix of different numbers as either an integer or to 1 decimal place.
Is there anything I can do just in the Num expression that would achieve this?
Num(Sum(Number), '#,##0.0') places everything at 1 decimal place, even integers.
Thanks for the help.
You may try conditional statement like:
=If(floor(Variable1)=Variable1, Variable1, Num(Variable1,'#,##0.0'))
Now replace Variable1 with your expression.
View solution in original post
Even Integer means, Do you have any different Types. Would you provide sample data and expected result?
Yes that is a good way of checking this thanks. I was looking more to see if it was possible in the Num expression formatting?