Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Number Format issue in 2 dimension Block/Pie charts

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? 

Capture-Block.PNGCapture-Pie.PNG

John

2 Replies
charlie_mstrmnd
New Contributor III

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

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

Not applicable

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

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