Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Passing Parameter into QlikSense Load script

Hi

I have just converted a few QlikView QVD generators into QlikSense and all has gone well....

..... until I started converting a QVD Generator for an incremental load.

This has an input parameter and its value controls the incremental load:

  • Positive number, Loads data that was updated since that many days ago
  • Zero, Loads since last reload started
  • Negative Number, Does a full load

For Dev testing in QlikView, in the script it uses the Input() function to pass the parameter into a variable.  This from the Help is not supported in QlikSense [In reality it is more than just not supported, the command simply does not exist]

In the QlikView QMC we have 2 seperate tasks:

  • Full Load task that passes a parameter of -1 into the script variable
  • Incremental Load task that passes a parameter of 0 into the script variable


I am pretty sure in QlikSense QMC tasks one cannot pass a parameter to populate a script variable.  [I certainly can see no way of doing this and no mention of it in the manual]


I see one can add a Tag to a QlikSense task and it would be a great work around if one could somehow reference that Tag in the load script.  But I ain't got a clue how one would do that, or indeed if it is even possible.



Any suggestions anybody ?






1 Reply
cjzimm76
Partner - Creator
Partner - Creator

Bill,

Any luck with passing variables to the load script editor in QS.  I am searching but I haven't found anyone who has a solutions to this yet.

Charlie