Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
suzel404
Creator
Creator

import data from WebSite

Hi all,

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

Coins , % volatilatility

Thanks for your  help.

Labels (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

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


Aufnahme_2017_07_13_21_41_17_557.gif

View solution in original post

52 Replies
Anil_Babu_Samineni
MVP
MVP

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
Master II
Master II

see attached file for workaround

hope this helps

suzel404
Creator
Creator
Author

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
Master II
Master II

i have modified the solution.

see attached file.

hope this helps

Frank_Hartmann
Master II
Master II

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

suzel404
Creator
Creator
Author

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
Master II
Master II

do you have this option in script enabled?

Unbenannt.png

Frank_Hartmann
Master II
Master II

and this option also  has to be enabled

Unbenannt.png

suzel404
Creator
Creator
Author

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