Need Help Regarding Currency Conversions

[#1]

Hi to All ,

I need help regarding currency conversions in qlikview

my data is like this

from currency to currency date conversion rate conversion factor

I need to convert the BRL's HKD's etc,,,

I have to calculate the billing value i tried in this way while writing expression in a pivot chart

if( pricing date=date,conversion rate*conversion Factor,0)

it says expression is ok but not displaying any results

Thanking u all a lot ...

Bradd

[erichshiino]

Hi,

You can create a data model to better solve this kind of problem.

Please, check this previous post with a lot of examples:

http://community.qlik.com/forums/t/38309.aspx