Load Web File dynamically

[eddysanchez]

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

[eddysanchez]

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 · Accepted solution]

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

[Anonymous]

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]

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

[eddysanchez]

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]

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

[chrisbrain]

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?

[jochem_zw]

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]

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