Change number formatting in expression - Qliksense

[RutiTaumanRubin]

Hi,

I have created the following measure:

if (Getfieldselections(Sales_type)='Percent',sum(per_sales)/100 ,sum(sales))

I want that the measure will display as percent when the user will choose the option 'Percent' else will display as number.

Is it possible?

Thank's!

[kaushiknsolanki]

Try this.

if (Getfieldselections(Sales_type)='Percent',num(sum(per_sales)/100,'#,##0%' ),Num(sum(sales),'#,##0'))

Regards,

Kaushik Solanki

[RutiTaumanRubin]

it doesn't work in if function....

[justinphamvn · Accepted solution]

Hi Ruti,

Try this.

if (Getfieldselections(Sales_type)='Percent',num(sum(per_sales)/100,'#,##0%' ),Num(sum(sales),'#,##0'))

And set Number formatting as Measure expression of the KPI properties

Regards,

Justin.

[RutiTaumanRubin]

Thank you for your response !

it's work and the measure display as percent but the Y-axis still appear as number format (0.8) , there is an option that the format of Y-axis will display also as percent ?

[justinphamvn]

Hi Ruti,

I think this option is not available yet for the current version of Qlik Sense

Regards,

Justin.