topic QlikSense Script Inquiry in App Development

QlikSense Script Inquiry

qwebnm — Wed, 08 Nov 2023 06:02:40 GMT

I have a question regarding the QlikSense script.

I am using a script similar to the one attached below:

LOAD empno,
ename,
hiredate,
sal,
// test,
deptno;

I am a bit confused and wonder if the script above is necessary.

In my opinion, applying the above script doesn't seem to make any difference, and I believe it won't generate any data.

It appears to me that two scripts with apparent duplication have been written.

Is my assumption correct? Or is there a reason for using it this way?

I suspect it might be a developer's mistake.

Additionally, in the script provided by the actual database connection, I noticed that it also includes similar lines.

Is there a specific reason for adding these Load statements? Or are they unnecessary?

If possible, I would appreciate your feedback and guidance on this matter.

Thank you.

Re: QlikSense Script Inquiry

qwebnm — Wed, 08 Nov 2023 06:01:41 GMT

Additionally, in the script provided by the actual database connection, I noticed that it also includes similar lines.

Is there a specific reason for adding these Load statements? Or are they unnecessary?

Re: QlikSense Script Inquiry

Adam_Romanowski — Wed, 08 Nov 2023 07:26:55 GMT

It's preceding load. As you can see, db connector generates code for first load to make calculations/transformations using qlik engine, while the second load is just SQL code to get data from database.

If you don't need to perform transformations for data already loaded into Qlik, you can remove first LOAD.

More details:

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/load-data-from-previously-loaded-table.htm