Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
OmarBenSalem

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
OmarBenSalem

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)

Anonymous
Not applicable
Author

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!!!

OmarBenSalem

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