topic Re: Calculating Currency in the Sum column in QlikView

Calculating Currency in the Sum column

Fri, 19 Apr 2013 11:37:51 GMT

Hej together,

i have a column with currency and a cloumn amount in one table

Amount	Currecncy
1212	EUR
2145	USD

The second Table is the USD and the eychange rate.

Currency	Change Rate
USD	0,8

Well, i want the Amount 2145 with the currency USD that calculate the amount with the change rate (0,8) an refresh the amount 2145 with the new amount of the change rate.

Could you help me.

Thank you.

Re: Calculating Currency in the Sum column

jvitantonio — Fri, 19 Apr 2013 11:49:09 GMT

LOAD * INLINE [

Amount, Currency

1212, EUR

2145, USD

];

left join LOAD * INLINE [

Currency, Rate

USD, 0.8

];

Final:

LOAD

if(isnull(Rate),Amount,Amount*Rate) as Amount, Currency

Resident A;

Drop table A;

Re: Calculating Currency in the Sum column

Sun, 21 Apr 2013 13:58:46 GMT

IT doesn't works.

The formula shows me only the EUROs and note calculatete Dollar in Euros.

Do you have an new tipp for me.

Thanks.