Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Vignesh
Hi,
yes you can do it. You can do it by selecting custom option in Number Formatting. (I did this in Combo chart).
Regards,
Prabhu Appu
Hi Prabhu,
The above suggestion is valid but my requirement is to do @ expression level
pls suggest if you can
Thanks,
Vignesh
Hi,
Yes you can do this but better you can do this in the load script.
Regards
Anand
hi,
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.
Kindly advise
Hi,
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...
Regards,
Prabhu Appu
yuppie but not working
Hi,
Then in expression use Num() to format
=Num(Sum(MeasureName), '#00%')
Regards,
Jagan.
Nope it is not working.
Any other suggesstions
Hi,
=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.
Regards,
Jagan.