topic Number Format issue in 2 dimension Block/Pie charts in QlikView

Number Format issue in 2 dimension Block/Pie charts

Tue, 23 Aug 2016 14:49:16 GMT

When I have a two dimension Block with a Num() in the expression, the top level numbers are not formatted, but the 2nd level numbers are formatted correctly. When I convert the object to one dimension, the number formats are correct.

Does anyone know how to fix it for the Block Chart?

John

Re: Number Format issue in 2 dimension Block/Pie charts

Anonymous — Tue, 23 Aug 2016 15:06:58 GMT

Hi John,

Why don't you apply the appropriate rounding to the expression:

E.g.

= Num(

IF(vCurrencyType = 'USD',

Round(Sum(SalesUSD)),

IF(vCurrencyType = 'EUR',

Round(Sum(SalesEUR))

)

), '$(vCurrencyFormat)' )

Charlie

Re: Number Format issue in 2 dimension Block/Pie charts

Tue, 23 Aug 2016 15:12:35 GMT

That would handle the number of digits, but it would not put the currency symbol in front of the number.