Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Rounding

Hi All,

I am working with a straight table where i need to round some values from

100,000,000.00 to 100.00

AND

if value is only two decimal palaces 0.11 no action is needed.

How can I work this into a formula?


Thank you

9 Replies
Not applicable

Re: Rounding

Hi,

Try something like this:

=num(sum(Expression),0.00)

Regards,

-Khaled.

Not applicable

Re: Rounding

Pl upload the application

shree909
Valued Contributor II

Re: Rounding

Try this

=round(sum(Expression),0.01)

it will round the values and display with 2 decimals

or if u want to list the first 2 decimals.

Goto the properties tab, select numbers theere u can modify the values accordingly..

or   =num(sum(Expression),0.01),' #,##0.00') it will exactly return 2 values...

Not applicable

Re: Rounding

That does not work for me. Any other suggestions?

shree909
Valued Contributor II

Re: Rounding

can u post a sample .so that we can figure out where exactly ur missing?

Not applicable

Re: Rounding

Dear zvirina123,

in the stright table goto Numbers tab and select the Particular expression and in the number format settings select the fixed to 2 decimal.

Thanks,

Mukram.

Not applicable

Re: Rounding

Here you go. Thank you for your help

shree909
Valued Contributor II

Re: Rounding

where exactly ur getting wrong..

i am able to display for the 2 decimals..

the thing is u marked in numbers as money format..

can u change that to decimal...

Not applicable

Re: Rounding

Now i am getting extra zeros. How can i hide it?

Community Browser