Discussion Board for collaboration related to QlikView App Development.
I am having trouble with using QlikView from the command line when passing variables using the QVP protocol.
1. My document has a variable called vFileID
2. I created a subroutine titled "AutoRun" and assigned this to run automatically on document open. (Document Properties > Triggers Tab > OnOpen > Edit Actions > Run Macro > AutoRun)
3. I call this QlikView document with the command line option -vvFileID=12345 to set the value of the variable from the command line.
This works beautifully if I open the file directly from the server file share. The variable is set and I can take action to filter the document on this value.
"c:\program files\QlikView\qv.exe" /vvFileID=12345 "\\muscobi\QlikView User Documents\SimpleDMS\SimpleDMS.qvw"
However, when I open the document on the server using the QVP protocol that the users need, the variables are not set. The file opens, and the autorun code fires, but the variables are empty.
"c:\program files\QlikView\qv.exe" /vvFileID=12345 "qvp://muscobi/AccessPoint/SimpleDMS/SimpleDMS.qvw"
Does anyone have any suggestions for getting this to work?
Go to Solution.
"c:\program files\QlikView\qv.exe" "qvp://muscobi/AccessPoint/SimpleDMS/SimpleDMS.qvw?vFileID=12345"
View solution in original post
So, nothing? I guess this is one for QlikView technical support, then.
I'm novice at macros and I'm encountering the same problem. I have two queries:
1- I'd like to know how I should insert this text:
"C:\Program Files\QlikView\Qv.exe" /vVariable=1 "\\MyUser\MyFolder\MyQV.qvw"
in the module editor within the subroutine body. For now, the editor tells me that it expects an statement.
Could anybody provide me with the complete macro code?
2- Next step for me will be also to achieve this with qvp path at server side. Has anybody confirm if it has been possible and provide with the correct qvd path syntax?
Thanks in advanced,
I just created a new document and ran into the same problem as I had with this one. Searching Google I found my original limitation.
Your suggestion works! Thank you!
I am running some macro code on load to make the selection based on the variable. This command line populates the variable as expected.
"C:\Program Files\QlikView\Qv.exe" "qvp://muscobi/AccessPoint/Customer Service/Invoice Lookup.qvw?vInvoiceNo=149120"
My macro to make the selection:
'set the InvoiceNo
if activeDocument.variables("vInvoiceNo").GetContent.String <> "" then
ActiveDocument.variables("vInvoiceNo").SetContent "", True