Discussion board where members can get started with Qlik Sense.
In Qliksense , Is there any way to format the numbers @ expression level irrespective of default number formatting.??
As i have formatted the numbers @ expression it is working in straight table but when i tried to do the same in Combo chart it is not working.
Kindly help me out.
Thanks in advance
Actually i dont want to do for the entire application instead i need to do for single analysis...
Let me be more clear by posting an example mentioned below.
I have a filter which has fields "Contribution & Qty"
So when i select Contribution i need to see the value in % and if i select Qty i should see in numbers
But the above should work one single chart.
You can use num function to format the numbers in Expression.
if(A='qty', num(Sum(SalesAmount),'#00'), num(Sum(SalesAmount),'#00 %'))
Hope you are looking for this...
=Num(0.8, '#00%') replace 0.8 with your expression
This is giving me 80%, I am not sure why you are not getting the correct format, try to remote the number format pattern in Format section.