Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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!