topic Re: round function in QlikView

round function

Wed, 12 Nov 2014 09:06:25 GMT

how we apply the round function in chart,and operate through slider.

Re: round function

ali_hijazi — Wed, 12 Nov 2014 09:12:28 GMT

use ceil or floor functions for rounding up or down respectively

Re: round function

Wed, 12 Nov 2014 09:16:08 GMT

ceil

Re: round function

ashfaq_haseeb — Wed, 12 Nov 2014 09:17:48 GMT

Hi,

Check this for better understanding.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors

Regards

ASHFAQ

Re: round function

marcus_malinow — Wed, 12 Nov 2014 09:21:43 GMT

Are you sure you want to use the round function? It may be that you can achieve what you're looking for by setting the number format of your expression. To do this, in the chart properties, go into the Number tab.

Re: round function

Wed, 12 Nov 2014 09:29:20 GMT

first i round the values in chart and this will operate with the help slider..and after number tab what can i do?

Re: round function

marcus_malinow — Wed, 12 Nov 2014 09:36:37 GMT

I'm not sure what you're trying to achieve with your slider. Can you explain please?

Re: round function

Wed, 12 Nov 2014 09:39:05 GMT

simply with help of slider we can change the values in chart..first ,how to use the round function in charts.

Re: round function

marcus_malinow — Wed, 12 Nov 2014 10:08:27 GMT

Ok if I understand you correctly, this may be one way.

Set up two variables:

vNumberOfDP - use this in your slider

vNumberFormat - set this to this expression

='#0.' & Left('0000000000', $(vNumberOfDP))

Then in your expression:

=num([existing expression], '$(vNumberFormat)')

Re: round function

vardhancse — Wed, 12 Nov 2014 10:58:01 GMT

ceil(x [ , base [ , offset ]])

Rounding of x upwards to the nearest multiple of base with an offset of offset. The result is a number.

Examples:

ceil( 2.4 ) returns 3

ceil( 2.6 ) returns 3

ceil( 3.88 , 0.1 ) returns 3.9

ceil( 3.88 , 5 ) returns 5

ceil( 1.1 , 1 , 0.5 ) returns 1.5

floor(x [ , base [ , offset ]])

Rounding of x downwards to the nearest multiple of base with an offset of offset. The result is a number.

Examples:

floor( 2.4 ) returns 2

floor( 2.6 ) returns 2

floor( 3.88 , 0.1 ) returns 3.8

floor( 3.88 , 5 ) returns 0

floor( 1.1 , 1 , 0.5 ) returns 0.5