topic Re: how to Round off the values in straight table in QlikView

how to Round off the values in straight table

Wed, 22 Mar 2017 10:58:49 GMT

Hi all,

I need % value should represent less than or equal to 100%, I am looking out for the rounding of values.can any one suggest me the best ideas you have so that it will be helpful for my learning process

For Example:

for 100.005 % : i need answer like 100% << like it should not cross 100 %>>

please find the below screen shots for your referance

Expression screen shots:

Number properties:

Thank you,

Muthukumar

Re: how to Round off the values in straight table

Frank_Hartmann — Wed, 22 Mar 2017 11:00:13 GMT

use Floor() function:

If(YourExpression>1,Floor(YourExpression), YourExpression)

hope this helps

Re: how to Round off the values in straight table

sunny_talwar — Wed, 22 Mar 2017 11:03:41 GMT

or Round() function

Re: how to Round off the values in straight table

vinieme12 — Wed, 22 Mar 2017 11:06:12 GMT

the first questing to ask is

Is the way you are calculating the expression correct?

Re: how to Round off the values in straight table

yoganantha321 — Wed, 22 Mar 2017 11:18:54 GMT

Hi Muthu,

=Round( Your expression *100)&'%'

It helps you.......