topic Re: Regarding Format Pattern Of Money In Bar Graph in QlikView

Regarding Format Pattern Of Money In Bar Graph

AbhijitBansode — Wed, 25 May 2011 06:47:01 GMT

Hi,

I want to change the format pattern in the bar graph dynamically.

e.g. if values are displaying in the range of Million doller then, want to diaplay value on the bar as $ 100M,$ 200M etc.

if the values are in the range of Thousand doller, then i want to diaplay value on the bar as $ 200K, $ 200K etc.

how to achieve this?

Re: Regarding Format Pattern Of Money In Bar Graph

Wed, 25 May 2011 07:45:41 GMT

Hi,

You can use the following expression:

If(SUM(Value) >= 1000000,

Num(SUM(Value), '#.##0 M'),

Num(SUM(Value), '#.##0 K')

)

Regards.

Regarding Format Pattern Of Money In Bar Graph

Wed, 25 May 2011 08:13:47 GMT

Hi,

I am not sure if you refer to this, but you can check Number tab inside Chart Properties and set values for Symbol, Thousand Symbol, Million Symbol...

Re: Regarding Format Pattern Of Money In Bar Graph

AbhijitBansode — Wed, 25 May 2011 09:12:22 GMT

Thank u for concern...

medina.. i've given all the settings in the Nuber tab of Chart properties already.

like in Symbol- $

Thousand - $K

Million - $M

Billion- $B

but this add the corresponding symbol on the y-axis,

my requirement is to show such symbol on independent bars of graph.

Magv, i'm actually looking for the same as suggested by you..

but i'm not getting that where should i put this condition.

because Format Pattern option under Number tab does not allow to use expressions.

Re: Regarding Format Pattern Of Money In Bar Graph

Mon, 02 Jul 2012 13:04:14 GMT

Some editing in Magv idea:

If(SUM(Value) >= 1000000,

Num(SUM(Value)/1000000, '#.##0 M'),

Num(SUM(Value)/1000, '#.##0 K')

)

Regards,

Surya

Re: Regarding Format Pattern Of Money In Bar Graph

Tue, 03 Jul 2012 18:59:27 GMT

Just add the symbol you want in the format pattern input box. this will display the symbol infromt of every number in the chart