topic Re: Rounding problem in QlikView

Rounding problem

Mon, 22 Feb 2016 10:10:30 GMT

I have one expression like overall days in my straight table.

It is showing the values in straight table like

345

356

323

123

555

123

But when i am exporting to excel it is showing the values

345.6

356.4

323.1

123.6

555.2

123.8

Now i am expecting the output when i am exporting the excel is like below.

346

357

324

124

556

124

Please advice.

Thanks for help in advance.

Re: Rounding problem

nagireddy_qv — Mon, 22 Feb 2016 11:28:42 GMT

use Money(),round() function in your expression.

Re: Rounding problem

arulsettu — Mon, 22 Feb 2016 11:28:44 GMT

ceil(your expression)

for ex:

ceil(sum(sales))

Re: Rounding problem

sunny_talwar — Mon, 22 Feb 2016 11:28:52 GMT

May be use this:

Ceil(YourExpression)

Re: Rounding problem

swuehl — Mon, 22 Feb 2016 11:29:21 GMT

What number format settings are you using on number tab in chart properties? I believe setting the format to integer should do what you want.

Could you post a small sample QVW?

edit: Missed that you do want to round upwards. Do you really want to do this?

Re: Rounding problem

Chanty4u — Mon, 22 Feb 2016 11:30:42 GMT

round(urfield)

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