Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number format error

Okay, I need help. When percent is checked, it's taking a fixed number such as 94.27, and making it 9427%.

Please note the Format 'Preview' in each image.

Please note the only difference between these images is my choosing 'Show in Percent (%)' on the bottom image.

Thank you,

variance.jpg

variance2.jpg

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

I assume that you want to display 94,27 as 94,27%. Well, checking the "Show in percent" will not just add a percentsign, but it will also multiply by 100 (since 1.0 is 100%). You should probably just divide the expression you have now with 100.

/HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

I assume that you want to display 94,27 as 94,27%. Well, checking the "Show in percent" will not just add a percentsign, but it will also multiply by 100 (since 1.0 is 100%). You should probably just divide the expression you have now with 100.

/HIC

Not applicable
Author

Henric, thank you!