topic Re: Dollar Calculation in QlikView

Dollar Calculation

pgalvezt — Thu, 13 Mar 2014 21:36:57 GMT

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!

Re: Dollar Calculation

chiru_thota — Fri, 14 Mar 2014 13:14:39 GMT

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

Re: Re: Dollar Calculation

pgalvezt — Fri, 14 Mar 2014 13:30:33 GMT

Hi Chiranjeevi Thota

Now you can access.

Thanks!

Re: Dollar Calculation

chiru_thota — Fri, 14 Mar 2014 18:35:57 GMT

Yes we can

Re: Dollar Calculation

chiru_thota — Fri, 14 Mar 2014 18:43:36 GMT

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

Re: Dollar Calculation

pgalvezt — Fri, 14 Mar 2014 19:25:05 GMT

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,

Re: Dollar Calculation

pgalvezt — Mon, 17 Mar 2014 15:57:50 GMT

Hello chiru.thota,

Could you get any solution?

Thanks.