Discussion board where members can get started with Qlik Sense.
I was wondering how I could show my measure field as a percentage.
E.g. if I had a value of 3, I would want to format it through 'Number formatting' to show as 3%.
I can't just add a '%' to the end of the 'Format Pattern' as it would show as 300%.
Help is greatly appreciated.
First divide measure field by 100 (measure/100) then format it through 'Number formatting' to show as 3%.
Sorry I should have mentioned that while that solution would typically work, I cannot use it in this context.
I am using an extension to create a radar graph but the axis only goes as low as 0.1 (I have no idea why).
A lot of my data have values lower than 0.1 so currently my radar graph currently looks very empty except for a bunch of lines bunched up in the centre. I need my data to actually have value over 0.1.
Thus what I want to do is: value*100 and add a % symbol to the end.
E.g. Turn 0.009 into 0.9 and show it as 0.9%.
You can also add a comma: