Execute Qlik Code stored in Excel

[rneelakantam]

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

[marcus_sommer]

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]

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.