Solved: import data from WebSite - Qlik Community

suzel404 · ‎2017-07-06

Hi all,

How can I import data from the Web site : Volatility Index | CryptoIndexes.com ?

Coins , % volatilatility

Thanks for your help.

Frank_Hartmann · ‎2017-07-13

Another thing. Please search this line in script:

if(num(purgechar(text(A),'#'))>196,Null(), text(A)) as Position

and replace it with:

A as Position

I was not aware that the Positions # can exceed 196.

Change it and it will be dynamically adapted

View solution in original post

Anil_Babu_Samineni · ‎2017-07-07

Looks like this is not share point link. I got same task when i was earlier task. That time, I realize and ask to the Owner of the Site and request to create that data in XML / JSON file. SO then, they share with me and i used the same ....

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Frank_Hartmann · ‎2017-07-07

see attached file for workaround

hope this helps

suzel404 · ‎2017-07-11

Frank,

Thank you so much, I need more details in my application.

How can I add the lowest price and the highest price ?

And then, how can I create an incremental for this data (I want to get back data from the web Site every 2 hours) to have an historical.

Many thanks,

Frank_Hartmann · ‎2017-07-11

i have modified the solution.

see attached file.

hope this helps

Frank_Hartmann · ‎2017-07-11

if you also need the script to be automatically reloaded every 2 hours then try attached solution

suzel404 · ‎2017-07-12

Thanks Frank, I encounter some issue, see attachment file (Allow Database Write and Execute statement in pref settings). I use save website.qvw to test. The incremental manually work but the field %vol give an holder value compare to the web site.

In the application I get back 19.97 for %vol but in the web site it's 32.72 and the volume doesn't match.

Many thanks for your help, great job until that.

Frank_Hartmann · ‎2017-07-12

do you have this option in script enabled?

Frank_Hartmann · ‎2017-07-12

and this option also has to be enabled

suzel404 · ‎2017-07-12

I activate checkboxes. But When I launch save website.qvw I see that.