Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

robert99
Valued Contributor II

Qlik Data Market Currencies No longer works

Hi

It was working fine for the free currencies. It didn't work just before Christmas. I thought it was down temporarily.

Its still not working. I need to know whether this has been discontinued as I need to do some work needing exchange rates

Thanks

DataMarket.JPG

1 Solution

Accepted Solutions
Not applicable

Re: Qlik Data Market Currencies No longer works

Hi Robert

Just ran mine and its running fine.

I see you need to make 2 more selections. (You need 3 green marks)

1.JPG

Regards

2 Replies
Not applicable

Re: Qlik Data Market Currencies No longer works

Hi Robert

Just ran mine and its running fine.

I see you need to make 2 more selections. (You need 3 green marks)

1.JPG

Regards

robert99
Valued Contributor II

Re: Qlik Data Market Currencies No longer works

Thanks

I can see what Qlik have done now

They have made a change maybe from 3.1.2 on. It doesn't work with the way I used the script anymore.

They use to load as separate tables. One for every currency

Like so

// from above Auto generated sheet

XRPound:

LOAD

   "Base currency",

    "Exchange rate"

RESIDENT [3x3 currency exchange rates]

where "Quote currency" = 'Pound sterling' ;

XRDollar:

LOAD

   "Base currency",

    "Exchange rate"

RESIDENT [3x3 currency exchange rates]

where "Quote currency" = 'US dollar' ;

XREuro:

LOAD

   "Base currency",

    "Exchange rate"

RESIDENT [3x3 currency exchange rates]

where "Quote currency" = 'Euro' ;

drop table [3x3 currency exchange rates] ;

but now its different. Using a link table instead

I will have give this some thought as I used Qliks market script for mapping tables

Community Browser