Solving problem - diving values and using different dimensions

silvia_assuncao — Tue, 19 May 2015 12:19:26 GMT

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:

Country	Rate_USD	Local_Value	Classification
Brazil	3,12	0	Depreciation / Amortization
Brazil	3,12	80	Hardware
Brazil	3,12	12	Others
Brazil	3,12	-99	Outsourced Services
Brazil	3,12	58	People
Brazil	3,12	72	Software
Brazil	3,12	-17	Telecom
Brazil	3,12	-4	Training
Brazil	3,12	-7	Travel
Argentina	8,7918	-22	Contractors
Argentina	8,7918	-33	Depreciation / Amortization
Argentina	8,7918	11	Hardware
Argentina	8,7918	1	Others
Argentina	8,7918	-4	Outsourced Services
Argentina	8,7918	1	People
Argentina	8,7918	-14	Software
Argentina	8,7918	1	Travel

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,

Re: Solving problem - diving values and using different dimensions

maxgro — Tue, 19 May 2015 16:06:15 GMT

Problem when divinding / multiplying

topic Re: Solving problem - diving values and using different dimensions in QlikView

Solving problem - diving values and using different dimensions

Re: Solving problem - diving values and using different dimensions