Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Num expression as integer when integer, else 1 decimal place

Hi,

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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

3 Replies
Highlighted

Even Integer means, Do you have any different Types. Would you provide sample data and expected result?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
MVP
MVP

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

Highlighted
Contributor III
Contributor III

Hi,

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?