Variable format

[#1]

New to Qlik. I created a variable name vSales. Once I start showing the variable in Text Object, it is showing as 24.456745 (multiple numbers after decimal point). Is there way I can get rid of numbers after decimal?

Thanks.

[#2]

try like this

=NUM($(vSales),'##0')

or

=Floor($(vSales))

[#3]

No luck..

I am getting "Error in Expression ')' expected"

[#4]

Let me know how expression and variable you have written

[maxgro]

look at these functions in Qlik help

floor ceil round

round( 2.4 ) returns 2

round( 2.6 ) returns 3

round( 2.5 ) returns 3

round( 3.88 , 0.1 ) returns 3.9

round( 3.88 , 5 ) returns 5

round( 1.1 , 1 , 0.5 ) returns 1.5

[#6]

Hello Muralidhar,

You can for sure use the above functions. I have however tried Uday's function and it is correct. I have created a variable vsales and referenced it in a text object and Uday'sfunction should work. Please see screen shot.

=num($(vSales),'##0')   as is should work

[Anonymous · Accepted solution]

Try

=round(vSales)

or

=round(vSales, 0.01)