Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?