If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
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%.
It seems like that the "num(value,'#,#0.0%')" formula works perfectly in table, but not in graph (at least does not work for me in scatter plot). Anyone has good solution? Appreciated!