Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

how to Round off the values in straight table

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

Screenshot_4.png


Expression screen shots:

Screenshot_5.png


Number properties:

Screenshot_6.png

Thank you,

Muthukumar

1 Solution

Accepted Solutions
Highlighted
Contributor II

Re: how to Round off the values in straight table

Hi Muthu,

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

It helps you.......

View solution in original post

4 Replies
Highlighted
Honored Contributor II

Re: how to Round off the values in straight table

use Floor() function:

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

hope this helps

Highlighted

Re: how to Round off the values in straight table

or Round() function

Highlighted
Esteemed Contributor II

Re: how to Round off the values in straight table

the first questing to ask is

Is the way you are calculating the expression correct?

Highlighted
Contributor II

Re: how to Round off the values in straight table

Hi Muthu,

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

It helps you.......

View solution in original post