Number formatting in Qliksense Bar Chart

[sridhar1]

Hi,

I have bar chart with Metrics Volume, Avg Selling Price and Margin % w.r.t Year. I am using Variable (Custom Extension Qlik Branch) to toggle the Metric on the Bar Chart but my bar shows only numbers. 

I need to show Number in Millions for Volume, $ Sign for Avg Selling Price and % Sign for Margin beside the numbers on the chart. I used below statement but doesn't work

if(vMetric=1, num(Sum(Volume),'#,##0.0M',

if(vMetric=2,num(Avg(Selling Price),'$##.00',

if(vMetric=3,num(Margin%),'##.00%')))

Let me know your suggestions please how to achieve this functionality.

Thanks

[jaimeaguilar]

Hi,

I'm not sure if this is possible in Qlik Sense. In QlikView, you have an option called "Expression default" under the number tab in object properties. However, I think you cannot achieve the same behavior in Qlik Sense because there is no such option.

It may be some workaround or maybe it would be mandatory to use an extension that can achieve this functionality,

regards

[Ivan_Bozov]

Hello! The brackets in your expression are a bit off.

If(vMetric=1, Num(Sum(Volume),'#,##0.0M'),

If(vMetric=2, Num(Avg([Selling Price]),'$##.00'),

If(vMetric=3, Num([Margin%],'##.00%'))))

[sridhar1]

Hi Ivan,

Sorry typo mistake but it doesn't work.

Thanks

[rubenmarin]

Hi Sridhar, usualy this can be done setting number format as auto, it works on tables but not on bar chart, a workaround can be keeping only a 2 decimals number and play with conditional title or subtitle to tell the metric.

[sridhar1]

Hi Ruben,

Yep I have done that mentioning it inTitle and Subtitle about the Metric but my users are not so exploring my options. And they want to see in Chart not in Tabular view .

Thanks

Sridhar