Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Round off to two decimals problem

Hey!

Let's say i have:

=sum([Antal arbetade timmar]/Timmar)

And the answer in the gauge chart is showing 0.49345565767672

When i press properties and choose number, and the choose "fixed to" and click the "show as %" it does not work? That means that nothing happends.

I have also tried the num function but i can't get that to word either, and how to i get it to show the % in the num funtion?

I want the gauge chart to show 49.3%

Thankfull for helping answer!

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi,

Let try =NUM(sum([Antal arbetade timmar]/Timmar),'00.0%')

Regards,

Sokkorn

View solution in original post

7 Replies
Sokkorn
Master
Master

Hi,

Let try =NUM(sum([Antal arbetade timmar]/Timmar),'00.0%')

Regards,

Sokkorn

Not applicable
Author

Yeah nice, thats the solution.

Do you know why the properties -> number -> "fixed to" does not work?

Thanks for the help!

Sokkorn
Master
Master

Hi,

For me it working fine (QV11 SR1).

Regards,

Sokkorn

Sokkorn
Master
Master

Can you upload your app?

Not applicable
Author

No not really since the data is real customer data! But thanks anyway, i guess it's just a wierd bug or something!

Sokkorn
Master
Master

That fine. What QV version you use?

Not applicable
Author

QV11 SR1, it's a personal licence.