Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how we apply the round function in chart,and operate through slider.
Hi,
Check this for better understanding.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors
Regards
ASHFAQ
use ceil or floor functions for rounding up or down respectively
ceil
Hi,
Check this for better understanding.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors
Regards
ASHFAQ
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.
first i round the values in chart and this will operate with the help slider..and after number tab what can i do?
I'm not sure what you're trying to achieve with your slider. Can you explain please?
simply with help of slider we can change the values in chart..first ,how to use the round function in charts.
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)')
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