topic Re: INR calculation in QlikView

INR calculation

rathnam_qv — Wed, 09 Apr 2014 06:03:07 GMT

Hi all,

i have straight table..in that i am calculating INR for USD as sum([Order Price])*60.04.

But the $ value is not constant as 60.04 i will change in future...how to get that value automatically to calculate.

Can anyone help me.

Regards,

Rathnam.

Re: INR calculation

vikasmahajan — Wed, 09 Apr 2014 06:21:08 GMT

You can upload Dollar rate using WebSite We can pick us rate and do calculation on this directly in Qv.

Vikas

Re: INR calculation

sundarakumar — Wed, 09 Apr 2014 06:21:15 GMT

It depends on how often u reload the application. If it is daily then u will have to fetche the daily rates from internet and put it in the variable place. If it is monthly then u will have to use the average for the month as the $ rate. now the thing is how u get the $ value of all the days, this u cn get it from any standard web sites like BLOOMBERG. U would need to connect with them to have the monthly data.. Pls let m,e know how often will u relaod the dashboard.

-Sundar

Re: INR calculation

rathnam_qv — Wed, 09 Apr 2014 06:30:37 GMT

Hi Sundarakumar,

Thanks for your reply.

reload happens on every day.

Regards,

Rathnam.

Re: INR calculation

Anonymous — Wed, 09 Apr 2014 06:34:21 GMT

Check and use this...

Re: INR calculation

sundarakumar — Wed, 09 Apr 2014 06:36:47 GMT

Hi,

Then its very easy, u cn fetch the data form the web site directly as another field and use the specific field for the variable that i have specified above. I think Blooomberg would be a best example. U ahve many other sotes which show the currency details.

Hope this helps.

-Sundar

Re: INR calculation

MK_QSL — Wed, 09 Apr 2014 06:38:37 GMT

Your order price would definitely belongs to some order number which have some order date..

Try to create another table with Date and USD and INR rate.

Now rename the Date or Rate table as order date and calculate accordingly...

Another option is to link Date and USD/INR rate from web site so you dont have to manually keep record of date vs rates...

Re: INR calculation

rathnam_qv — Wed, 09 Apr 2014 06:50:41 GMT

Hi Manish,

Thanks for ur reply.

can u please send me sample app

Re: INR calculation

MK_QSL — Wed, 09 Apr 2014 06:52:14 GMT

if you can send your sample data with different rates, will try to create apps for you.

Re: INR calculation

preminqlik — Wed, 09 Apr 2014 06:58:20 GMT

hi Hope this attachment helps you !

-Many Thanks

Premhas

Re: INR calculation

Wed, 09 Apr 2014 06:58:34 GMT

You can Maintain an Excel in format [From Date] , [To Date],Rate .

and using interval match you can apply the rate to your order price in your scripting.

Himank