Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
And what I get is this:
Is there something that I don't understand about decimal numbers here?
Hi, if you acces script editor, at the begining of script there are some variables that sets number formats:
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.
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?
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.
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?
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.
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:
Have you tried 0.0% as format?
Or #,##0.0%
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.