Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vigneshvs
Contributor II

Number formatting in Qlik sense Charts

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

Tags (1)
14 Replies
prabhuappu
Contributor II

Re: Number formatting in Qlik sense Charts

Hi,

yes you can do it. You can do it by selecting custom option in Number Formatting. (I did this in Combo chart).

Q1.PNG

Q2.PNG

Regards,

Prabhu Appu

vigneshvs
Contributor II

Re: Number formatting in Qlik sense Charts

Hi Prabhu,

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

pls suggest if you can

Thanks,

Vignesh

Re: Number formatting in Qlik sense Charts

Hi,

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

Regards

Anand

vigneshvs
Contributor II

Re: Number formatting in Qlik sense Charts

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
Contributor II

Re: Number formatting in Qlik sense Charts

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

vigneshvs
Contributor II

Re: Number formatting in Qlik sense Charts

yuppie but not working

MVP & Luminary
MVP & Luminary

Re: Number formatting in Qlik sense Charts

Hi,

Then in expression use Num() to format

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


Regards,

Jagan.

vigneshvs
Contributor II

Re: Number formatting in Qlik sense Charts

Nope it is not working.

Any other suggesstions

MVP & Luminary
MVP & Luminary

Re: Number formatting in Qlik sense Charts

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.