Currency Daily Updating

[miro_kopecky]

Hi
I have avarage salary of employees in 5 cities in the table and i need to change these amounts from euros to usd and czech crowns.

And these rates of currencies have to be loaded from this website and daily updated in that app https://www.nbs.sk/sk/statisticke-udaje/kurzovy-listok/kurzovy-listok-vybranych-cudzich-mien-voci-eu...

i am still beginner working with qlik and i would really apprieciate any your help

thanks in advance

[dwforest]

Create a new connection to a Web File using that URL and it will find the table and let you import it

[zebhashmi]

try to use Rest API Connection

[miro_kopecky]

Okay, I've got it loaded now in the fields but how do i make that euros will be changed for usd in daily updating?

[martinpohl]

the daily rate you can store into a qvd

(see https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements...

for details.

at the load script from courses add

today() as RateDate

so you have the date the rate belongs.

Also store the daily rates into daily qvds.

In your data model load all rate qvds and link rate date to datas.

For former rates you have to create datas.

Regards