Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QMC - load task with parameter

hello,

i successfully created a task within qmc, which is updated every single day.

now i want to extend my app to be loaded with the latest system date.

example:

LOAD *;

SELECT *

FROM "db_mydb"."tbl_Latest" WHERE sys_date = to_date('$(next_sysdate)','DD.MM.YYYY');

how and where can i define next_sysdate as parameter in the QMC, so that my load-script can be updated correctly.

i am using qlik sense 3.0.

can you guide me ?

thx in advance

1 Reply
rzenere_avvale
Partner - Specialist II
Partner - Specialist II

Anyone on this topic?