topic Re: Passing parameters from one qvw file to another in QlikView

Passing parameters from one qvw file to another

eiconsulting — Fri, 04 Sep 2009 15:28:48 GMT

I saw some posts but none shows a simple way to pass one or two parameters to a new .qvw file you open with a button, such as from a "parent" menu app to a child data-crunching app.

Any hints at where to look for?

Thanks

Flavio

Passing parameters from one qvw file to another

prieper — Fri, 04 Sep 2009 23:44:16 GMT

Hi Flavio,

saw something in announcement for version 9.0 - but have never tried to do so.

Peter

Passing parameters from one qvw file to another

Fri, 04 Sep 2009 23:51:21 GMT

I don't know if I understood your question correctly, would passing the variable values through command line help you? i.e. qv.exe /r /Variable=value

Passing parameters from one qvw file to another

Anonymous — Sat, 05 Sep 2009 00:57:41 GMT

No need for /r unless you want to reload. Only /v to assign variable value.

Peter, there is action "Open QlikView Document" in QV9, and it can copy the selections. Here it is from "help":

Open QlikView Document

Opens the specified document and applies the selections of the original document. The file extension must be included.

Mark the check box Transfer State to transfer the selections from the original document to the one you wish to open. The opened document will first be cleared of selections.

Mark Apply state on top of current to retain the second document's selections and apply the original document's selections on top of them.

Passing parameters from one qvw file to another

eiconsulting — Mon, 07 Sep 2009 17:13:50 GMT

Thanks, I would have hoped for an API like Application.Document.Variable("1") ... 😉 but passing a parameter in the command line could work. I want to emulate the security passing its parameters to another file (if you set it you don't have to retype you login with all new files). I need my own additional security built-in.

Problem is that it gives me an error "Failed to execute qv.exe". I also set the variable in the 'second' file so that only the value would have to be passed (after another post advice).

I used the execute action behind a button:

Application qv.exe

Filename xxxxxx.qvw

Parameters /v%Test='aaa' (the variable name is %Test ?)

Directory omit as it is the same

The Transfer State transfers only the selections? Is it possible that "undocumented" there are some other "hidden" options that I could use?

Flavio

Passing parameters from one qvw file to another

eiconsulting — Thu, 10 Sep 2009 15:19:11 GMT

My final answer came after a suggestion from QV and some experimenting. I tried to get out all specific references and italian language (hope it still works 😉 Thanks to all that contributed. If anybody needs to make it clearer I can attach a sample.

This code should be in the "menu" file that needs to open a "secondary" file and set a variable there with a value that was set in the first one.

The secondary file should just have a variable with that name defined. Both documents are left open.

<code/>

sub runDoc

set Var=ActiveDocument.Variables("Var_A_01")

set App=ActiveDocument.GetApplication

set UserFile = App.OpenDoc ("filename.qvw","","")

set v = UserFile.Variables("Var_B_01")

v.SetContent Var.GetContent. String,true

ActiveDocument.ClearAll false

end sub

</code>

Passing parameters from one qvw file to another

Thu, 24 Sep 2009 13:10:24 GMT

Hi Flavio,

Actually am new to QlickView.

I have the requirement which sounds similar to this.

I have one document where am showing the list of reports to the user, then the user will select the reports as per his wish.

Once he clicks on one report name, that specific document should open up in other window(which is another Qvw document), and again the user should able to come back to the original document to select other document as well.Its something like calling other document from the existing one / navigating from one document to other.

Am i clear here?

Could you please help me out in this ?

Thanks in adavance,

Mahasweta

Passing parameters from one qvw file to another

eiconsulting — Thu, 24 Sep 2009 15:39:02 GMT

Hi! I am not sure I can attach a sample. There are around a qvw-launch and qvw-target to exemplify this solution using the Transfer State option that Michael above was suggesting. This makes available on the second doc all selections you had on the launching app.

You can very simply, though, create a button and with the Action tab/External launch another qvw file without any code. The same you can do with an action on whatever object in your target doc making you able to go back to the "Main menu" feature.

My "solution" was more specifically about passing some parameters, such as information you gather with your first "screen" that you want to use in the second without writing it to a database but keeping them as variables. As for the "Report", if you mean literally, I have never used that function in QV but sure you can open a new file and launch any function "On Open" provided you are able to write some code (see the API guide).

Flavio

Re. :Passing parameters from one qvw file to another

Thu, 24 Sep 2009 16:01:22 GMT

There's a good example of this feature :

Just watch in the "What's New in QV9.qvw" file, and look at the "View Finance" Button on the DashBoard Sheet (bottom left), which launch the "Finance Controlling.qvw" file with parameters...

Enjoy,

Eric.

Re. :Passing parameters from one qvw file to another

eiconsulting — Thu, 24 Sep 2009 17:00:30 GMT

Yes! This is a fantastic example of opening a new doc and passing "selections" (i.e. elements from the data structure). I had overlooked it when looking for this kind of solution.

The final solution I proposed, instead, passes (sort of shares) parameters as doc variables.

Thanks, hope that this leads to a solution for Mahasweta

Flavio

Passing parameters from one qvw file to another

Mon, 28 Sep 2009 21:42:40 GMT

Hi Flavio,

If possible could you please attach the Sample.

Thanks a lot,

Pratul.

Passing parameters from one qvw file to another

eiconsulting — Tue, 29 Sep 2009 15:39:26 GMT

Unfortunately I cannot, tried without success even messages go out very slowly. Must be a question of firewall etc. that I have no time to investigate further. I'll try again as soon as I can.

Sorry

Flavio

Passing parameters from one qvw file to another

Anonymous — Wed, 17 Nov 2010 11:02:35 GMT

Hi Michael, I am trying to reload one qvw file thru another using execute /r and its reloading too BUT I want to pass some variables too using /vVariableName=value into the called file but its not working. Can u pls help me in this.

Passing parameters from one qvw file to another

Tue, 08 Feb 2011 10:54:37 GMT

Hi Mahasweta,

I tried to implement your solution and wonder whether this works also from Accesspoint. How the Second .qvw is opening from first .qvw

did u implement this one?

Regards

Sravan


Mahasweta wrote:
Hi Flavio,
Actually am new to QlickView.
I have the requirement which sounds similar to this.
I have one document where am showing the list of reports to the user, then the user will select the reports as per his wish.
Once he clicks on one report name, that specific document should open up in other window(which is another Qvw document), and again the user should able to come back to the original document to select other document as well.Its something like calling other document from the existing one / navigating from one document to other.
Am i clear here?
Could you please help me out in this ?
Thanks in adavance,
Mahasweta
 <div></div>

Passing parameters from one qvw file to another

jagannalla — Fri, 17 Jun 2011 12:21:17 GMT

Flavios,

I tried with your code to transfer a variable with data to another qvw file. I written your code in button action but when i'm clicking the button it displays "Fail to open document" in message box. I'm working on QlikView 10.

when i click the ok button it shows the error in macro code like this..

How can i overcome this...

Re: Passing parameters from one qvw file to another

Thu, 23 Jun 2011 05:23:34 GMT

Hi Flavios,

I used your below code, in that i need to create a new variable in another QVW file through macro code. And should pass the parameter of one QVW to another QVW.

sub runDoc

set Var=ActiveDocument.Variables("Var_A_01")

set App=ActiveDocument.GetApplication

---> //HERE I NEED TO CREATE A VARIABLE i.e; "VAR_B_01" in macro code.

set UserFile = App.OpenDoc ("filename.qvw","","")

set v = UserFile.Variables("Var_B_01")

v.SetContent Var.GetContent. String,true

ActiveDocument.ClearAll false

end sub

How it is possible.

Pls share your ideas on this.

Regards

Venkat

Re: Passing parameters from one qvw file to another

neetu_singh — Tue, 16 Oct 2012 08:54:11 GMT

Hi,

Can you share the sample file as i need to pass the selection from one qvw to another qvw.

Re: Passing parameters from one qvw file to another

ali_hijazi — Tue, 27 Nov 2012 08:34:27 GMT

may you please supply us with sample documents

Re: Passing parameters from one qvw file to another

Thu, 11 Apr 2013 15:15:08 GMT

Can yo attach sample file?

Re: Passing parameters from one qvw file to another

Thu, 11 Apr 2013 15:15:31 GMT

Can yo attach sample file?