topic QMC - load task with parameter in QlikView https://community.qlik.com/t5/QlikView/QMC-load-task-with-parameter/m-p/1370091#M418842 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>i successfully created a task within qmc, which is updated every single day.</P><P></P><P>now i want to extend my app to be loaded with the latest system date.</P><P></P><P>example:</P><P><EM>LOAD *;</EM></P><P><EM>SELECT * </EM></P><P><EM>FROM "db_mydb"."tbl_Latest" WHERE sys_date = to_date('$(next_sysdate)','DD.MM.YYYY');</EM></P><P></P><P>how and where can i define <EM>next_sysdate</EM> as parameter in the QMC, so that my load-script can be updated correctly.</P><P></P><P>i am using qlik sense 3.0.</P><P></P><P>can you guide me ?</P><P></P><P>thx in advance</P></BODY></HTML> Mon, 10 Apr 2017 09:58:50 GMT 2017-04-10T09:58:50Z QMC - load task with parameter https://community.qlik.com/t5/QlikView/QMC-load-task-with-parameter/m-p/1370091#M418842 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>i successfully created a task within qmc, which is updated every single day.</P><P></P><P>now i want to extend my app to be loaded with the latest system date.</P><P></P><P>example:</P><P><EM>LOAD *;</EM></P><P><EM>SELECT * </EM></P><P><EM>FROM "db_mydb"."tbl_Latest" WHERE sys_date = to_date('$(next_sysdate)','DD.MM.YYYY');</EM></P><P></P><P>how and where can i define <EM>next_sysdate</EM> as parameter in the QMC, so that my load-script can be updated correctly.</P><P></P><P>i am using qlik sense 3.0.</P><P></P><P>can you guide me ?</P><P></P><P>thx in advance</P></BODY></HTML> Mon, 10 Apr 2017 09:58:50 GMT https://community.qlik.com/t5/QlikView/QMC-load-task-with-parameter/m-p/1370091#M418842 2017-04-10T09:58:50Z Re: QMC - load task with parameter https://community.qlik.com/t5/QlikView/QMC-load-task-with-parameter/m-p/1370092#M418843 <HTML><HEAD></HEAD><BODY><P>Anyone on this topic?</P></BODY></HTML> Sun, 16 Jul 2017 09:05:10 GMT https://community.qlik.com/t5/QlikView/QMC-load-task-with-parameter/m-p/1370092#M418843 rzenere_avvale 2017-07-16T09:05:10Z