topic Re: Need help on Call parameter on QMC in QlikView

Need help on Call parameter on QMC

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

I have 5 tables in my extract.qvw file, out of this 2 tables are from database1 (DB1)to be scheduled at 8:00 AM and remaining tables are from database1 (DB2) to scheduled at 9:00AM

I came to know that this can be done through QMC by passing parameter name and parameter value in Reload Tab , so here there will be two tasks where one should run at 8 Am and other at 9 AM

pls help

John

Re: Need help on Call parameter on QMC

Peter_Cammaert — Thu, 25 Jun 2015 08:49:42 GMT

You'll need a Publisher for that.

See QMC->Source Documents->Select document->Task->Reload->Script Parameters. Enter a variable name in the top input box and a value that controls which QVDs will be stored by your document in the lower one.

Note that the variable must exist before script execution is started. Create the variable in the Variable overview instead of in your script. If you manipulate your variable in your script with LET/SET v=value, then you'll always loose the passed value.

QMC Help contains more information on how to set this up and how to pass multiple values (for example to create multiple end-user documents)

Peter

Re: Need help on Call parameter on QMC

Gabriel — Thu, 25 Jun 2015 11:21:40 GMT

Hi,

What I will do in this case is to split my script into 2 part using variable (i.e. vReloadTime) See below for example. Still pass the variable into QMC i.e. QMC->Source Documents->Select document->Task->Reload->Script Parameters.

Set up two task 8:00 AM and 9:00 AM using same qvw file.

Like this.

IF vReloadTime = 0 THEN

//Reload 8:00 AM script

tb1:

LOAD

FROM DB1;

STORE tb1 INTO \\..........;

ELSE

//Reload 9:00 AM script

tb2:

LOAD

FROM DB2;

STORE tb2 INTO \\.......;

ENDIF

Re: Need help on Call parameter on QMC

Anonymous — Thu, 25 Jun 2015 11:55:25 GMT

Thanks Gabriel , would you please elaborate what needs to be given in parameter name and parameter value in QMC, for the above example.

John

Re: Need help on Call parameter on QMC

Gabriel — Thu, 25 Jun 2015 11:59:40 GMT

Hi,

Goto QMC, select Documents tab -> Source Documents tab then click on the + sign to navigate to the qvw file you want to split the task. Then click on the Edit Task button (it's Pencil like shape) the select Reload tab. Here you will find where you can enter Parameter Name and Parameter Value

Re: Need help on Call parameter on QMC

Anonymous — Thu, 25 Jun 2015 12:08:20 GMT

Thanks Gabriel, not sure whether I'm asking the right question or not, what if 8:00 AM job gets failed,and then I run it manually, how does this gets executed.

John

Re: Need help on Call parameter on QMC

Gabriel — Thu, 25 Jun 2015 12:11:04 GMT

I think you can set the retry number in QMC as well. The job will reload if it fails again & again for the number of retries you entered. Or you can reload manually

When 8:00 AM fail it won't affect the 9:00 AM job