topic Re: Pass a variable value to a QlikView Document in QlikView

Pass a variable value to a QlikView Document

joshabbott — Tue, 23 Sep 2014 19:35:39 GMT

Is it possible to have a trigger in QlikView that will 'Open QlikView Document' and pass that document a value for a variable?

For instance, say I have a document called doc1.qvw

I also have a variable called var1 in doc1.qvw

When they click a button on another document, I would like to 'Open QlikView Document' doc1.qvw and set the value of var1 = 1. I tried:

doc1.qvw&var1=1

and this doesn't seem to work, I'm thinking since it is the 'Open QlikView Document' action, it isn't recognizing the passing of parameters for the variable value

Re: Pass a variable value to a QlikView Document

Anonymous — Tue, 23 Sep 2014 20:13:55 GMT

You need to mark "Transfer State"

Re: Pass a variable value to a QlikView Document

joshabbott — Wed, 24 Sep 2014 12:41:07 GMT

I tried this, and it didn't copy the variable value over. Is that what you were thinking it would do?

Re: Pass a variable value to a QlikView Document

ashfaq_haseeb — Wed, 24 Sep 2014 13:01:16 GMT

Hi,

This is not supported you can vote for the Idea here.

http://community.qlik.com/ideas/2359

if you can you use the QVP protocol instead then use below

qvp://YourServer/Doc.qvw?&myvar=1

Regards

ASHFAQ

Re: Pass a variable value to a QlikView Document

sundarakumar — Wed, 24 Sep 2014 13:05:34 GMT

If possible u can create an inline field with all the possible values of variable and select it in the first document which will be passed to the second document through document chaining if u create the same inline field in second document.

-Sundar

Re: Pass a variable value to a QlikView Document

joshabbott — Wed, 24 Sep 2014 13:24:04 GMT

I think this is the right track. Based on passing that through a field named MyState (for instance, 1), I'd like a different sheet to be opened. I tried both on change on the inline field, and on open of the second qvw, and it isn't working correctly. It will only change the sheet to the first sheet in the field even if MyState = 2.

=If(Only(MyState) = 1, 'SH01', 'SH02')

Re: Pass a variable value to a QlikView Document

joshabbott — Wed, 24 Sep 2014 13:33:37 GMT

I'm attaching an example:

doc1.qvw has inline load of MyState (1 or 2). It also has a button ('OPEN DOC') that opens a QlikView document doc2.qvw and transfers state

doc2 has two sheets (SH01 and SH02). It also has the same inline load of doc1.qvw. There are actions on open of the document and on select of MyState:

=if(Only(MyState) = 1, 'SH01', 'SH02')

If I change the values around on doc, and open the new doc, it doesn't take me to the new sheet but does carry over the selection. From doc2, if I make different selections, it changes the sheet. Any ideas? Thank you for everyones help!

Re: Re: Pass a variable value to a QlikView Document

joshabbott — Wed, 24 Sep 2014 13:35:57 GMT

Ooops, attachments:

Re: Pass a variable value to a QlikView Document

rubenmarin — Wed, 24 Sep 2014 13:39:11 GMT

Also you can create a macro:

sub OpenDoc

set App = ActiveDocument.GetApplication

set newdoc = App.OpenDoc(".\test2.qvw")

Set v = ActiveDocument.Variables("Var")

Set v2 = newDoc.Variables("Var")

v2.SetContent v.GetContent.String, true

end sub

Re: Pass a variable value to a QlikView Document

dmohanty — Tue, 31 Jan 2017 15:37:27 GMT

Hi joshabbott‌,

You can achieve this in below way, but make sure you do the data validation after document is chained.

Make sure both the documents have the same variable.
Open document properties in Document 1 (source document) and go to Variable tab.
Then for each variable that you want to pass to the Document 2 (Chained document), check the box 'Include in bookmark' in Document 1.

As QlikView server uses bookmark when chaining document, it will pass the variables values to the new opened application, like for the selections.

Let us know if this helps!