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

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

alec1982 — Wed, 12 Sep 2012 20:15:06 GMT

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

Wed, 12 Sep 2012 20:18:10 GMT

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

MayilVahanan — Wed, 12 Sep 2012 20:19:43 GMT

Can you say in detail?

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

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

alec1982 — Wed, 12 Sep 2012 20:20:14 GMT

Hi,

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

Best,

Wed, 12 Sep 2012 20:21:00 GMT

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

alec1982 — Wed, 12 Sep 2012 20:21:01 GMT

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

above is my expression.

Thxs

alec1982 — Wed, 12 Sep 2012 20:26:16 GMT

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

Thxs,

Wed, 12 Sep 2012 20:26:50 GMT

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