topic Re: Re: Set variable value from command line using "/v" in QlikView

Set variable value from command line using "/v"

Mon, 03 Nov 2014 16:54:45 GMT

I am trying to test out the ability to pass a variable and value from the command line using the following:

"C:\Program Files\QlikView\QV.exe" /r /vParameterTest=1234 "C:\Desktop\QVW_QW\PatternTrending\reports\PatternTrending.qvw"

In my scripts tab, i declared a variable called "test" that is assigned the value from the passed in variable - "ParameterTest" so that I can then display that value on a text object to see if the value was passed in correctly but it is null.

Set test = ParameterTest;

Any help, please?

Re: Set variable value from command line using "/v"

Gysbert_Wassenaar — Mon, 03 Nov 2014 17:13:27 GMT

"C:\Program Files\QlikView\QV.exe" /r /vParameterTest=1234

This will assign the value 1234 to the variable ParameterTest. If you want to assign the value 'ParameterTest' to a variable called test then you need:

"C:\Program Files\QlikView\QV.exe" /r /vtest=ParameterTest

Re: Set variable value from command line using "/v"

Anonymous — Mon, 03 Nov 2014 17:17:36 GMT

For your text object give it the expressions of :

= $(ParameterTest)

That should display 1234 & if so then you should be ok.

I am not sure you actually need the other variable called "test".

Re: Set variable value from command line using "/v"

Mon, 03 Nov 2014 17:18:57 GMT

Right, I understand that it will assign the value 1234 to the variable ParameterTest. Since I read that you can only use variables passed in from the command line in your script or macro function, I created another variable called "test" so that I can assign the value from ParameterTest and display the value in a text object on the GUI.

My text object value is set as: "=test"

Re: Set variable value from command line using "/v"

Anonymous — Mon, 03 Nov 2014 17:20:50 GMT

Yup , it is the dollar expansion you need.

Re: Set variable value from command line using "/v"

Gysbert_Wassenaar — Mon, 03 Nov 2014 17:23:12 GMT

Since I read that you can only use variables passed in from the command line in your script or macro function

That's not correct. There's only one kind of variable. If you have a variable you can set its value from the command line, or in the script (with the SET and LET statements) or in the Variable Editor or with actions assigned to triggers. The variables can be used in the script and in expressions in chart objects etc. So you don't need to create another variable to get the value from a variable that got its value via a command line option.

Re: Set variable value from command line using "/v"

Mon, 03 Nov 2014 17:25:21 GMT

I actually tried that before too but no luck. I tried it with and without the enclosed $(). Just tried it again but no dice.

Re: Re: Set variable value from command line using "/v"

Anonymous — Mon, 03 Nov 2014 17:28:51 GMT

So did you use = $(ParameterTest) as the expression in your Text Object ?

Re: Set variable value from command line using "/v"

Mon, 03 Nov 2014 17:33:35 GMT

Here's what I have and not working.

Re: Set variable value from command line using "/v"

Anonymous — Mon, 03 Nov 2014 17:36:57 GMT

In Settings | Variable Overview what does it show for your variables ?

Re: Set variable value from command line using "/v"

Mon, 03 Nov 2014 17:38:01 GMT

Null

Re: Set variable value from command line using "/v"

Anonymous — Mon, 03 Nov 2014 17:43:34 GMT

Aaahh !! So you have nothing in your variable ParameterTest

I usually pass the parameter in at the end of the command, as in :

"C:\Program Files\QlikView\QV.exe" /r C:\Desktop\QVW_QW\PatternTrending\reports\PatternTrending.qvw" /vParameterTest=1234"

*****************

Or does something later in your script reset the variable ?

Re: Set variable value from command line using "/v"

Mon, 03 Nov 2014 17:52:35 GMT

? The variable is showing null as it's value after running the command line. I am not defaulting it to anything, I am relying on having it set by the command line.

I don't think the ordering matters (maybe), as you show in your command line example but I gave it a shot and still did not work for me.

Re: Set variable value from command line using "/v"

Anonymous — Mon, 03 Nov 2014 17:55:32 GMT

Can you post your qvw ?

Re: Set variable value from command line using "/v"

Mon, 03 Nov 2014 18:08:25 GMT

Unfortunately, the firewall at work will prevent me from doing so.

Can't believe this is not working for me and for something so simple taking forever to get working. I am running this simple test so that eventually I can pass in 2 variables, 1 would be a Trading Exchange name and the other a database connection properties file as I have to load data from 2 different Trading Exchanges having the same tables that are structured the same. I want to set it up as 1 QVS import script for both Exchanges so that it dynamically query the data into seperate qvd files (ie. C1_quotes_data.qvd, C2_quotes_data.qvd) and then have my main application concatenate the 2 qvds into 1 (ie. quotes_data.qvd) to use as the source for the reports.

Re: Re: Set variable value from command line using "/v"

Anonymous — Mon, 03 Nov 2014 18:14:25 GMT

I have just tested it by creating a new qvw with this in the load script

trace $(ParameterTest) ;

set vCheck = $(ParameterTest) ;

trace $(vCheck) ;

Via Settings / Variables manually created blank variable ParameterTest

Called it like this

C:\Users\bill.markham>"C:\Program Files\QlikView\QV.exe" /r /vParameterTest=qwerty C:\Users\bill.markham\Downloads\ParameterTest.qvw

And got this in the log file:

03/11/2014 18:08:36: 0013 trace qwerty

03/11/2014 18:08:36: 0013 qwerty

03/11/2014 18:08:36: 0015 set vCheck = qwerty

03/11/2014 18:08:36: 0017 trace qwerty

03/11/2014 18:08:36: 0017 qwerty

03/11/2014 18:08:36: Execution finished.

That all seems ok, could you try those steps ?

Re: Set variable value from command line using "/v"

Tue, 04 Nov 2014 16:22:25 GMT

This morning, I turned on the logging and reran the command line execution (without yet trying your example above). The darn thing works now for some reason! I tried turning off the logging to see if it would still work and it does. I didn't make any other changes today before that.

Another strange thing is that for my text box source, i had "=$(ParameterTest)", it was displaying the value ok for a few runs and then it was displaying null again all of a sudden for subsequent runs. I went to Settings -> Variable Overview, and i saw that the value was being correctly set even though it was displaying null. I changed my text box source to "=ParameterTest" and now it is working consistently.

Weird.

Re: Set variable value from command line using "/v"

Wed, 05 Nov 2014 17:18:33 GMT

Thanks all for the help! Much appreciated.

After getting my test working, I am now able to do what I was ultimately trying to do - to run the same scripts for 2 different databases containing data for 2 different trading exchanges (having the same table structures), creating a separate set of qvd files for both databases and then merge them into 1 qvd file.