topic Re: Variable format in QlikView

Variable format

Sat, 09 May 2015 04:49:50 GMT

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.

Re: Variable format

Sat, 09 May 2015 04:59:29 GMT

try like this

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

=Floor($(vSales))

Re: Variable format

Sat, 09 May 2015 05:32:58 GMT

No luck..

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

Re: Variable format

Sat, 09 May 2015 05:45:51 GMT

Let me know how expression and variable you have written

Re: Variable format

maxgro — Sat, 09 May 2015 11:58:04 GMT

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

Re: Variable format

Sat, 09 May 2015 12:14:50 GMT

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

Re: Variable format

Anonymous — Sat, 09 May 2015 13:59:31 GMT

Try

=round(vSales)

=round(vSales, 0.01)