Currency convertion

[Anonymous]

I have a problem with the currency exchange guy I have two fields in the table one is of amount and the other is of currency type, what I can not do is that if the currency type is equal to 1 I convert all the amounts into dollars Of the field amount and if the exchange rate is equal to 2 m and I convert all the amounts in euros of the amount field.

I do not know if you let me understand to get help about it from now on thanks for the collaboration.

Ie as shown in the image select the type of currency and I convert all the amounts

[sangeess21]

This link may help you

https://community.qlikview.com/thread/16376

[sudeepkm]

you could create a table with currency and respective conversion rate that you want to apply to your amount.

The moment end user selects the Currency the rate would be applied to the amount field.

You also need to keep the amount in a native currency rate so that the conversion will be applied based on that.

Your Amount expression would have like Sum(Amount)*Rate.