Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Highlighted
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.

Community Browser