topic Stop Numbers Rounding by Default in QlikView

Stop Numbers Rounding by Default

matthewjbryant — Fri, 29 May 2015 09:11:27 GMT

I've been working with Qlikview for a year, but have never come across this. I've just reloaded a QVW and all the numbers are rounding to 0 d.p. by default. On every table box or straight table I have to set the number style to regain the accuracy.

Something must've be pressed by accident. Is there a document setting that does this?

Re: Stop Numbers Rounding by Default

mrossoit — Fri, 29 May 2015 09:16:06 GMT

Hi,

check your settings in Document Properties -> Number tab

Regards,

Re: Stop Numbers Rounding by Default

matthewjbryant — Fri, 29 May 2015 09:17:55 GMT

All fields still set to Mixed. Survive Reload is ticked.

Re: Stop Numbers Rounding by Default

mrossoit — Fri, 29 May 2015 09:41:01 GMT

Did you backup your qvw with others version names during last year? Also old versions round to 0 by default?

You should try if it's a behaviour related only to this qvw or if all your files treat numbers in the same mode.

QlikView version have been updated during this period?

Re: Stop Numbers Rounding by Default

GauravSarode — Thu, 03 Jun 2021 09:43:34 GMT

I am facing the same issue. After upgrading QV from 12.10 to 12.50 SR2, numbers are auto rounded. I have to manually set the format in document settings. Can you please suggest workaround for this in order to stop auto rounding values from fields in my data model.