Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Contributor III
Contributor III

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
Author

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