Dollar Calculation

[pgalvezt]

Hello,

I have tables that calculate ammounts by invoices. That invoices is in ($)Pesos. I need to convert this pesos in dollars. I took the table on internet that bring me all 2013 but Im not sure if Im doing good. The idea is select a date and when change the selection to dollar qlikview must bring the dollar (The conversion).

I attached an example what a want.

PD: Actually Im connected to field Dollar but that field dont bring me the dollar as well. If you do clic on dolar the margin is move the idea is keeping the same margin in pesos and dollars (Actually is moving). I dont know if bring the table of dollar change in internet is a good idea. If you guys have another idea I appreciate that.

Thank you!

[chiru_thota]

Application is not getting opened.It is asking for User ID.Do you have section access on it ?

[pgalvezt]

Hi Chiranjeevi Thota

Now you can access.

Thanks!

[chiru_thota]

Yes we can

[chiru_thota]

Why do we have String instead of Value for Column Valor_Factor ?

[pgalvezt]

Hi,

Is the way that I have to call the dollar from the txt file

If(Factor='Dólar (USD)', (sum({<Cuenta={'31010101','31010102','31010103','31010104','31010105'}>}Monto_Dolar)),(Sum(Aggr(sum({<Cuenta={'31010101','31010102','31010103','31010104','31010105'}>}Monto*-1 /Valor_Factor),Factura))))

But I don´t know if be the better way,

[pgalvezt]

Hello chiru.thota,

Could you get any solution?

Thanks.