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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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?