Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have one ptoblem with QlikSense
I want to load information from website by url, but I want to see this url in script
for example in Qlikview I can create this script
Like:
LOAD
"type",
id as [UserID],
first_name,
last_name,
%Key_response_9466E14D029DB307
(XmlSimple, table is [response/items/user]);
but this script doesn't work in Qlik Sense.
In Qliksense I can only use
Like:
LOAD
"type",
id,
first_name,
last_name,
%Key_response_9466E14D029DB307
FROM [lib://Like]
(XmlSimple, table is [response/items/user]);
[lib://Like] this line is automatic. Instead this line I need see url in QlikSense.
Thanks a lots
This text was helped me
In Qlik Sense deactivate the Standard Mode in Qlik Management Console -> Engine Properties.
In Qlik Sense Desktop open the file C:\Users\{user}\Documents\Qlik\Sense\Settings.ini in a text editor. Change StandardReload=1 to StandardReload=0. Save the file and restart Qlik Sense.
This text was helped me
In Qlik Sense deactivate the Standard Mode in Qlik Management Console -> Engine Properties.
In Qlik Sense Desktop open the file C:\Users\{user}\Documents\Qlik\Sense\Settings.ini in a text editor. Change StandardReload=1 to StandardReload=0. Save the file and restart Qlik Sense.
I know this is way late but here is the solution that I just found
The Surprising Power of Web File Data Connections in Qlik Sense | by Austin Spivey | Medium
[Scoring Stats load]:
LOAD
RK,
TEAM,
GP,
PTS,
"FGM-FGA",
FG%,
"3PM-3PA",
"3P%",
"FTM-FTA",
FT%
FROM [lib://ESPN (qlikcloud_qlikid_yourUserID)]
(URL is "http://www.espn.com/mens-college-basketball/statistics/team/_/stat/scoring/sort/points/year/2002/cou...", html, codepage is 28591, embedded labels, table is @1);
Create a LIB to any endpoint that works then use the "URL is" script specifier and then you can pass variable values to any portion of the URL you want to iterate through.