Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
rneelakantam
Partner - Contributor
Partner - Contributor

Execute Qlik Code stored in Excel

Hi All,

I have my Qlik code store in Excel. Now i want to load from excel and execute the code in Qlik.

Note : I cant store the code in txt or qvs file and use include script

 

Thanks in Advance

 

 

Labels (1)
2 Replies
marcus_sommer
MVP
MVP

You could load the excel and then pick from this load your needed fieldvalue respectively concat and/or aggregate multiple columns/rows and assign it to one or several variables and use them to perform your real loadings. It's quite the same like the content of the include-variables - and it must contain valid code.

Depending on the complexity of the code and the way how the code is stored in columns/rows it might not very easy to implement such logic. Therefore what is the reason for not using a Qlik application and/or include-variables?

- Marcus

rneelakantam
Partner - Contributor
Partner - Contributor
Author

HI Marcus,

Client is not ready to move the code from Excel to txt such that i can use Include script to load it directly.

Also Client wants to change the scripts frequently which would meet their requirements without moving the applications to PROD.