Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Based on the below image, I am having two number format issues when developing in Qlik Sense:
Thank you.
At the end I was able to close the two points.
With
SET NumericalAbbreviation='6:M;-6:M';
I was able to avoid the G and K and display just millions.
The orevious also fixed the discrepancy between the legend and the graph.
The thing is that when I publish the app in the server (replacing the existing one) the data was not correctly displayed and was fixed uploading it as a new one. Don't know if this is a real issue of the QMC.
At the end I was able to close the two points.
With
SET NumericalAbbreviation='6:M;-6:M';
I was able to avoid the G and K and display just millions.
The orevious also fixed the discrepancy between the legend and the graph.
The thing is that when I publish the app in the server (replacing the existing one) the data was not correctly displayed and was fixed uploading it as a new one. Don't know if this is a real issue of the QMC.
Hi Huichunchang,
Could you please share an example without real data and without the script (just the sets) so I could take a look?
What do you have in the script editor for the SET NumericalAbbreviation?
Thank you.
Best regards.
Based on your expression:
In case you just want to show ¥, what happens if you try replacing the NumericalAbbreviation by the following?
SET NumericalAbbreviation='3:k ¥;6:M ¥;9:G ¥;-3:k ¥;-6:M ¥;-9:G ¥';
Once we have the previous info I understand that we could do what you are trying to achieve.
Thank you.
@Vince_CH So you have two possibilities here:
why are you dividing the expression by /1000?
If in Aspects-->Colour and Legend -->Select measure and you delete the /1000 it should work