Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eddysanchez
Partner - Creator
Partner - Creator

Load Web File dynamically

Hi all

For load a web file in Qlik Sense is mandatory to define the connection with the specific link?

I need to load a web file that the source is made by variables like that:

[https://domain.com/$(vYear)/$(vMonth)/File.XLS]

Any suggestion?

thank you

Att

Eddy

1 Solution

Accepted Solutions
Michael_Tarallo
Employee
Employee

Hi Eddy - in order to use the "legacy" type load statement (without lib) - you must change a setting - in the settings.ini file to disable Standard mode.

The help document is here:

https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/WorkingWith/Content/LoadData/Disab...

This will enable you to use the http call like it is done in QlikView and with the use of variables.

Otherwise - you can still use variables with the lib statement - BUT you would need to make a connection for each URL.

If you need a sample, please let us know.

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik

View solution in original post

53 Replies
eddysanchez
Partner - Creator
Partner - Creator
Author

If I use the same script of QlikView, don't work and show the next message error:


LOAD statement only works with lib:// paths in this script mode



Michael_Tarallo
Employee
Employee

Hi Eddy - in order to use the "legacy" type load statement (without lib) - you must change a setting - in the settings.ini file to disable Standard mode.

The help document is here:

https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/WorkingWith/Content/LoadData/Disab...

This will enable you to use the http call like it is done in QlikView and with the use of variables.

Otherwise - you can still use variables with the lib statement - BUT you would need to make a connection for each URL.

If you need a sample, please let us know.

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Anonymous
Not applicable

Hi Michael,

The "legacy" mode seems like a good idea to be a "default" one as it gives more flexibility in creating a connection strings to data sources.

Would you pass this suggestion to the team, please?

Best regards,

Janusz

Michael_Tarallo
Employee
Employee

Hey Janusz -

Yes - in fact that is the plan - direct from the product manager's mouth:

"We are going to revert the default back to legacy to allow custom connect until the new connectors are available for Sense."

Regards,


Mike

Regards,
Mike Tarallo
Qlik
eddysanchez
Partner - Creator
Partner - Creator
Author

Michael, where I can send suggestions for Qlik Sense?

I miss the next shorcut combinations:

Ctrl+E = Data load Editor

Ctrl+R = Load data

Ctrl+Shift+R=Partial Reload (If still exist)

Ctrl+T = Data model viewer

Ctrl+Alt+V = Variables

Att

Eddy

Michael_Tarallo
Employee
Employee

Hi Eddy

This is the place for that as well - we will send ideas and suggestions to the R&D team.

In the mean time here are some shortcuts you may find useful where applicable to Qlik Sense.

Standard:

https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/Qlik_Management_Console_help/Conte...

Additional - (after the gestures)

https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/WorkingWith/Content/UserInterface/...

Regards,

Mike

Regards,
Mike Tarallo
Qlik
chrisbrain
Partner - Specialist II
Partner - Specialist II

Hi Mike,

This currently looks like a major issue for the many QVSource users out there (and general Qlik users loading from web urls) who rely on being able to construct URLs as the load script runs.

Could you clarify a couple of things from this thread?

  • You mentioned 'Otherwise - you can still use variables with the lib statement - BUT you would need to make a connection for each URL.'
    • What does this mean exactly, can the URL behind a lib statement read variables (initial tests suggest not) or do you need to create a connection for every unique URL?

  • Yes - in fact that is the plan - direct from the product manager's mouth: "We are going to revert the default back to legacy to allow custom connect until the new connectors are available for Sense."
    • This sounds like the reversion back to the legacy mode as default will be temporary, is that right?
beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
jochem_zw
Partner Ambassador
Partner Ambassador

Hi Mike,

How about Qlik Sense Server, do we also need to change a setting.ini for legacy support?

Where is this setting.ini?

reg. Jochem

Michael_Tarallo
Employee
Employee

Hey Chris - nice to hear from you, in regards to your questions:

  • You mentioned 'Otherwise - you can still use variables with the lib statement - BUT you would need to make a connection for each URL.'
    • What does this mean exactly, can the URL behind a lib statement read variables (initial tests suggest not) or do you need to create a connection for every unique URL?

If you use the lib statement - it is expecting a defined connection which is read from the list of connections stored in the repository - and if set up with security rules, it will respect those as well. So if a variable is used with the LIB statement such where the variable's values can be something like connection1 or connection2  - the actual connection names connection1 and connection2 must be defined to the correct data sources.

  • Yes - in fact that is the plan - direct from the product manager's mouth: "We are going to revert the default back to legacy to allow custom connect until the new connectors are available for Sense."
    • This sounds like the reversion back to the legacy mode as default will be temporary, is that right?

Yes - you are correct, this will happen with the next minor update release, I am being told.

HTH

Mike

Regards,
Mike Tarallo
Qlik