Number formatting in Qlik sense Charts

[Anonymous]

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

[prabhuappu]

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

[Anonymous]

Hi Prabhu,

The above suggestion is valid but my requirement is to do @ expression level

pls suggest if you can

Thanks,

Vignesh

[its_anandrjs]

Hi,

Yes you can do this but better you can do this in the load script.

Regards

Anand

[Anonymous]

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

[prabhuappu]

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

[Anonymous]

yuppie but not working

[jagan]

Hi,

Then in expression use Num() to format

=Num(Sum(MeasureName), '#00%')

Regards,

Jagan.

[Anonymous]

Nope it is not working.

Any other suggesstions

[jagan]

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.