Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

mstoler
Contributor II

can publisher set a variable in a QlikView File

Hello,

Is there a way to have Publisher set a variable to a value in a QlikView File.

Thank You,

Michael Stoler

5 Replies
Not applicable

can publisher set a variable in a QlikView File

Yes, you can set a variable in the parameter section of the reload tab when editing the task in QEMC.

Not applicable

can publisher set a variable in a QlikView File

Yes it can. On the Reload tab of publisher task, you'll see two fields, Parameter name and Parameter value under "Script Parameters". You can set more than one variable by separating the variables using semi-colon ";".

Hope that helps.

Vikas

peter_wissel
New Contributor

Re: can publisher set a variable in a QlikView File

Hi vikasbhasin,

how do you get it work to pass two parameters at the publisher frontend?

It works fine with two parameters when I start a batch script but not in the publisher frontend: Here´s my configuration:

Parameter name: vBatchPlant;vEnviroment;

Parameter value: 104;PROD;

Do you have an idea?

Kind regards,

P. W.

Highlighted
Not applicable

Re: Re: can publisher set a variable in a QlikView File

Peter,

Based upon our implementation attempts, it seems that the publisher "Parameter Name" is meant to be a single variable name, and then publisher will iterate one reload per value specified in the "Parameter Value" field.    That's our interpretation, we've not tried to get confirmation.

We have reasons where we sometimes want to pass in multiple variables to a reload task, but we aren't looking for publisher to iterate multiple times--we just want to pass in more than one variable to a single reload operation.    To do this, we built a small routine which allows us to pass a text string (in the parameter value field) that has one or more name/value pairs, so we can send in as many parameters as we need.   

Sample attached, in case you/others find it of value.   It's worked for our purposes.

- Brett

peter_wissel
New Contributor

Re: Re: can publisher set a variable in a QlikView File


Hello Brett,

in the meanwhile I had a similar looking idea to solve the problem. My version is quite more simple and absolutly not documented. Many thanks for your good solution!

Kind regards,

Peter W.

Community Browser