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

[Anonymous]

Hope your did the try in Combo chart....

If not pls do so..

As i have tried the same thing in the combo chart with the same formatting irrespective of default format i could not see the expected output

[prabhuappu]

Hi,

I tried in Combo chart only. It is coming correctly for me (Refer the tooltip). Are you expecting value to be showed on data point... Post your sample application

Regards,

Prabhu Appu

[Anonymous]

Hi Prabhu,

Could you pls tell me Whether the same works when you use the filter which i have mentioned earlier in this post???

If so pls post the sample app

[prabhuappu]

Hi,

It cannot be achieved directly but we can do a workaround for that.

1. You need to create an inline table with the format specifier

Load Metric,

Text(value) as value; //It is necessary to convert this to text, otherwise Qliksense will treat it as number

LOAD * INLINE [

    Metric, Fmt

    Contribution, '00.00%'

    Qty, '00.00'

];

2. In chart use below Expression,

if(Metric='Qty', Count([Key1]),

if(Metric='Contribution',num(Count([Key1])/Count(Total Key1), '$(=Fmt)'),

0))

3. Add a list in a sheet for Metric field,

Based on the selection in the Metric field the chart will be showing the Measure in corresponding format specifier.

This might not be the best solution... Because selecting in a list box is not like Qlikview. Every time it asks to confirm.

Regards,

Prabhu Appu

[raajeshn]

Hi Prabhu,

I had a similar issue - and your solution worked like a charm. THANK YOU.

Thanks & Regards,

Raajesh N