Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

silvia_assuncao
Contributor

Problem when divinding / multiplying


Hello All!

I'm having a problem when dividing values in Local Curreny by USD Rate for different countries in order to have them all in American Dolar Currency. I using the expression:

Sum(Local_Value)/(Rate_USD)

Below you can see my table:

   

CountryRate_USDLocal_ValueClassification
Brazil3,120Depreciation / Amortization
Brazil3,1280Hardware
Brazil3,1212Others
Brazil3,12-99Outsourced Services
Brazil3,1258People
Brazil3,1272Software
Brazil3,12-17Telecom
Brazil3,12-4Training
Brazil3,12-7Travel
Argentina8,7918-22Contractors
Argentina8,7918-33Depreciation /
  Amortization
Argentina8,791811Hardware
Argentina8,79181Others
Argentina8,7918-4Outsourced Services
Argentina8,79181People
Argentina8,7918-14Software
Argentina8,79181Travel

The problem is that Using this expression I have the righ values if I select a charge using dimension as Contries, but if I change the dimention to Classification, the values get all wrong.

Could you suggest me how could I fix my expression so that no matter what kind of dimention, I'd have the right values always?

Thanks and best Regards,

1 Reply
MVP
MVP

Re: Problem when divinding / multiplying

try

Sum( Local_Value / Rate_USD )

Community Browser