topic [ask] Converting value in barchart in QlikView

[ask] Converting value in barchart

Tue, 21 Sep 2010 04:10:42 GMT

Hello all,

newbie need your help pliss,

thank you before..

my problem is,

how to convert value in barchart?

i can convert the axes value, but i cannot convert the barchart value

plis see this picture,

i have two expression, which is

Sales = sum(TotalAR) and

Account receiveable = sum(Angsuran),

i have tried to use this solution,

add an axpression like this,

num(ceil(Sum (TotalAR)/1000000),'0 Juta')

but it can only convert 1 barchart,

i add an expression like that again, which is,

num(ceil(Sum (Angsuran)/1000000),'0 Juta'),

but it's the same, only can convert 1 barchart value,

does anybody have a good solution?

thank you...

Best Regards !!

Tue, 21 Sep 2010 04:36:27 GMT

hi ,

Just use the following expressions and see the result.... I think it will work for you...

Sales = sum(TotalAR)/1000000

Account receiveable = sum(Angsuran)/1000000

Regards,

Nilupa

Wed, 22 Sep 2010 03:01:14 GMT

thank you nilupa,

and at number tab, add the simbol

😄

regards