Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
Below you can see my table:
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,
Sum( Local_Value / Rate_USD )