topic Re: Execute Qlik Code stored in Excel in QlikView

Execute Qlik Code stored in Excel

rneelakantam — Wed, 29 May 2019 08:16:04 GMT

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

Re: Execute Qlik Code stored in Excel

marcus_sommer — Wed, 29 May 2019 11:15:54 GMT

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

Re: Execute Qlik Code stored in Excel

rneelakantam — Wed, 29 May 2019 13:07:58 GMT

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.