Solved: =NUM(expression, '#,##0.0%') is not working in a b... - Qlik Community

alec1982 · ‎2012-09-12

Any ideas!

I know that I could add the % symbol through the number tab. but here it is required to be added in the expression.

Thxs for your help

alec1982 · ‎2012-09-12

My bad, Needed to set expression defult in the Number tab.

Thxs,

Report Inappropriate Content · ‎2012-09-12

Use Num(expression,'##.#%')

MayilVahanan · ‎2012-09-12

Hi

Can you say in detail?

Its working for me correctly.. What expression are you using?

Did you try Num#(expression,'#,##0.0%') also?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

alec1982 · ‎2012-09-12

Hi,

Thxs for your quick reply but this didn't help.

Best,

Report Inappropriate Content · ‎2012-09-12

Then the problem is with your expression, as Mayil mentioned. What is your expression?

alec1982 · ‎2012-09-12

NUM(((Sum([Headcount (Current)])/(Sum([# of Private Offices])+Sum([# of Workstations])))*100),'##.#%')

above is my expression.

Thxs

alec1982 · ‎2012-09-12

My bad, Needed to set expression defult in the Number tab.

Thxs,

Report Inappropriate Content · ‎2012-09-12

Okay good deal. I tried your expression and it worked fine on my side

=NUM(expression, '#,##0.0%') is not working in a bar chart expression