topic Re: Fetching data from website in QlikView

Fetching data from website

amruta_j — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I need help in fetching data from website. I want to extract data from below link:

http://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=12371

When I'm extracting data from this link, I can see variables as @1, @2, but cannot see the data.

I'm not sure what is the problem.

Thank You in advance.

Re: Fetching data from website

amruta_j — Mon, 09 Jul 2018 09:29:22 GMT

Someone please help me. This link is not giving me data for selected variables.

Thanks in advance.

Re: Fetching data from website

Anil_Babu_Samineni — Mon, 09 Jul 2018 11:28:17 GMT

This is not the Files attachment share point link. And this is just web site using HTML script.

Re: Fetching data from website

Peter_Cammaert — Mon, 09 Jul 2018 12:22:44 GMT

I think this table on the internet is too complex to be handled by the simple Web Files filter that is builtin into the Script Engine. Most of this table is generated by selections and complex JavaScript code, and you may have to create your own import filter to handle its contents in a decent way.

As an alternative, have a look at the Qlik Web Connectors - Qlik Connectors to see whether they can be of assistance.

Re: Fetching data from website

Frank_Hartmann — Mon, 09 Jul 2018 12:47:05 GMT

May be you could copy the website content to an excel file by macro and then load the excel file in QV Script.

See attached qvw for solution