Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Qlik Sense load script from a text file

Is it possible for Qlik Sense's load script to be stored in a text file and referenced instead of the code directly entered?

Example:

In QlikView, my QVWs' code was all stored in associated text files for ease of editing.

QVW Load Script

----------------------------------------------------------------------------------

//Connection

$(Include=hq-datahouse1-datawarehouse.txt);

//QVD Path

$(Include=qvdpath.txt);

//Main Script

$(Include=loader_dim_hour.txt);

----------------------------------------------------------------------------------

the loader_dim_hour.txt was your standard

SQL SELECT * FROM ......

It worked great. 

The Connection string and the QVD Path is easy enough to store and manage as a new data connection in Sense, but what about the script itself?

Thank you

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

please refer to :

Using Include in Qlik Sense

the point is to use lib connections or permit the use of full paths (unceck the standrard reloard mode)

View solution in original post

3 Replies
Highlighted
Partner
Partner

please refer to :

Using Include in Qlik Sense

the point is to use lib connections or permit the use of full paths (unceck the standrard reloard mode)

View solution in original post

Highlighted
Contributor III
Contributor III

Bingo! Thank you very much.

Yup, I just made a shared data connection to a folder containing the text of my load script logic and referenced it thus...

$(Include=[lib://PATH/LoadScript.txt]);

p.s.

No paces!!!

Highlighted
Partner
Partner

good  ! happy it's worked !

Don't forget to close the thread by marking my response in this case as correct

Have a nice day