Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
sridhar1
New Contributor III

Number formatting in Qliksense Bar Chart

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

5 Replies
Partner
Partner

Re: Number formatting in Qliksense Bar Chart

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

Luminary
Luminary

Re: Number formatting in Qliksense Bar Chart

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
New Contributor III

Re: Number formatting in Qliksense Bar Chart

Hi Ivan,

Sorry typo mistake but it doesn't work.

Thanks

Re: Number formatting in Qliksense Bar Chart

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
New Contributor III

Re: Number formatting in Qliksense Bar Chart

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