topic Limiting an output to a integer in QlikView

Limiting an output to a integer

Thu, 13 May 2010 10:39:49 GMT

Hi,

In an expression I am using ' / ' (divide) operator.

I want to limit the output to a integer.

How can I do it

Regards,

Rohit

Limiting an output to a integer

Thu, 13 May 2010 10:45:06 GMT

Hi,

If you are dividing a number by number it obviously return number.

i`m not able to understand the problem .

Can you pl ellaborate a bit and post your expression as well here.

-Peretson

Limiting an output to a integer

Thu, 13 May 2010 11:00:27 GMT

Thanks Kevin for showing interest.

Actually I want to exclude the digits after the decimal.

Is that possible

Limiting an output to a integer

Thu, 13 May 2010 11:03:15 GMT

hi,

use div() function

ex:div(n1,n2)

thanks

Limiting an output to a integer

Thu, 13 May 2010 11:03:21 GMT

Hi,

You can use num() function to format you expressionn output.

like num(sum(Sales),'#,##')

if you are using charts you can go to number tab and format you o/p.

- Peterson

Limiting an output to a integer

Thu, 13 May 2010 11:17:36 GMT

Thanks a lot for your replies..

div(n1,n2) worked..it was great

Limiting an output to a integer

Thu, 13 May 2010 11:22:10 GMT

Hi,

If you are dividing a number by number like this:

=5/3

Ans: 1.6666666666667

If you need to make limit like this:

=num( 5/3, '0.00' )

Ans: 1.67

Is it your answer?

i think i m not able to understand the problem .

Zaman