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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Tomih
Contributor
Contributor

Two decimal separators in percentage presentation

Hello all! Just started my journey in the fascinating world of Qlik Sense and run into a strange issue with my first dashboard: I have a table with a % column and cannot understand the presentation of the numbers. 

What I define is this:

qs1.jpg

And what I get is this:

qs2.jpg

Is there something that I don't understand about decimal numbers here?

Labels (1)
10 Replies
rubenmarin1

Hi, if you acces script editor, at the begining of script there are some variables that sets number formats:

rubenmarin_0-1646816934684.png

Check if this variables are ok with your loaded number formats, you will need to reload the app to apply any changes made to this variables.

Tomih
Contributor
Contributor
Author

Thanks, will have to try. Just to understand correctly: those variables set the separators for parsing the data and the actual output formats are then specified in the UI. Is that correct?

rubenmarin1

Yes, it's the default format it expects to deal with numbers.. still I don't know what can be readed to be show as that number in your screenshot but sometimes I found numbers with many decimal and it was caused by number format, so I think it's the first thing to check.

That's to set the defualt, ther is naother funtion Num#() to set input number format for specific numbers that doesn't uses the default format. And the Num() function to set the output format of a number.

If all the data loaded has the same number format you should be ok with just setting the initial variables and the output format in the UI.

Tomih
Contributor
Contributor
Author

Ok, now it works and shows e.g. '99.4%'. But if I change the formatting in the UI from Simple to Custom and set the format to be '0,0%' (which btw. shows an example '1,0,0,0,1,2%) '99.4%' becomes '9,9%' and '100,0%' becomes '1,0,0%'. Really cannot understand the logic here.

What I want is to use comma as decimal separator and space as thousand separator in the presentation which is the local standard. How do I make that happen?

rubenmarin1

Hi, can you show me an example of the values you are loading? An image that shows the value in a table without applying any format.

And even better if it's the value in the source.

In your number 99.4 is using dot as decimal separator, so dot should be used as decimal separator in custom format.

Tomih
Contributor
Contributor
Author

The expression that I use as a measure in the table is simply Count ([xxx])/Count (TOTAL [xxx]).

What I want to have is '0,6%' and '99,4%'. 

What I get with different options is this:

qs3.jpg

rubenmarin1

Have you tried 0.0% as format?

rubenmarin1

Or #,##0.0%

Tomih
Contributor
Contributor
Author

Thanks for the replies again. Those both work but don't fulfil my need which is to have comma as decimal separator and space as thousand separator.  I will give up with this now.