topic Re: align numbers using non-breaking space in QlikView

align numbers using non-breaking space

curiousfellow — Mon, 26 Feb 2024 10:36:10 GMT

In my chart I have percentages and normal numbers.
I want to align the normal numbers by adding a space but so far I did not succeed.

To format the percentages I use num(number,'#.##0,0%')

for the normal numbers I thought I could use num(number, '#.##0,0'&chr(160)) however that does seem to work.

Adding an other character works fine, but a "non breaking space' does not.

Anyone knows how to solve this ?

Re: align numbers using non-breaking space

JonnyPoole — Thu, 22 Feb 2024 13:17:20 GMT

Share a screenshot of the chart as well as the property you are applying this to. Maybe it will accept the item as a text field too text(num(number, '#.##0,0') & ' ') but I'm not sure.

Re: align numbers using non-breaking space

curiousfellow — Mon, 26 Feb 2024 10:25:36 GMT

adding the text function did not help.Please have a look at the screenshot and the attached qvw