Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

INR calculation

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.

10 Replies
vikasmahajan

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
sundarakumar
Specialist II
Specialist II

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

rathnam_qv
Creator
Creator
Author

Hi Sundarakumar,

Thanks for your reply.

reload happens on every day.

Regards,

Rathnam.

Anonymous
Not applicable

Check and use this...

sundarakumar
Specialist II
Specialist II

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

MK_QSL
MVP
MVP

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...

rathnam_qv
Creator
Creator
Author

Hi Manish,

Thanks for ur reply.

can u please send me sample app

MK_QSL
MVP
MVP

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

preminqlik
Specialist II
Specialist II

hi Hope this attachment helps you !

-Many Thanks

Premhas