topic Format number in Text in Chart in QlikView

Format number in Text in Chart

guyvermeiren — Tue, 31 May 2011 14:48:52 GMT

Hello,

I would like to fomat my numbers in my calculated Text in Chart.

I tried this to have a thousand separator but without success

='Target='&Num#(vTargetOpptyNL,'#.#')

Any idea how to ?

Thanks,

Guy

erichshiino — Tue, 31 May 2011 14:58:04 GMT

num# will convert a text into a number. You need num() that will make the opposite:

try this:

='Target='&Num(vTargetOpptyNL,'#,###', '.', ',')

That's if your thousand sep. is , and your decimal sep is .

If vTargetOpptyNL is an expression, you may need to evaluate it:

='Target='&Num($(vTargetOpptyNL),'#,###', '.', ',')

='Target='&Num($(=vTargetOpptyNL),'#,###', '.', ',')

Hope it helps,

Erich