topic Re: BUTTONS in QlikView

BUTTONS

qlikview979 — Mon, 11 May 2015 14:49:42 GMT

Hi experts,

I have opened two QVW's in two files. now i want perform some action using button. if i can do any selection in one QVW file through button then the result will happen in another QVW file is it possible ? if possible how to send the variables one QVW to another QVW through button ?

Re: BUTTONS

mrossoit — Mon, 11 May 2015 14:58:23 GMT

Hi,

you have to use macro:

sub openQvw

set App = ActiveDocument.GetApplication

set file2 = App.OpenDoc(second_file_name, "", "")

set vPass1 = file2.Variables("v1")

vPass1.SetContent "Value1",true

end sub

Obviously in the second qvw you want to open from the first, there must be defined a variable (v1) for every parameter you want to pass.

Hope it helps

Regards

Re: BUTTONS

Bill_Britt — Mon, 11 May 2015 15:03:03 GMT

Hi,

Do a search for Document Chaining.

Bill

Re: BUTTONS

qlikview979 — Mon, 11 May 2015 15:11:34 GMT

thanks for sharp reply

can you explain with one example ?

Re: BUTTONS

Mon, 11 May 2015 15:14:28 GMT

Have you tried this:

Create a button

go to Action tab

Add Action

Choose External from the Action type Window

Choose Open QlikView Document from the Action Window

Specify the document that you want to link to

Mark the check box Transfer State

This is all yo need I think.

Re: BUTTONS

mrossoit — Mon, 11 May 2015 15:19:26 GMT

Regards

Re: BUTTONS

mrossoit — Mon, 11 May 2015 15:28:18 GMT

If you want to automatically change selections on your second qvw you could create an event on a field resident in your first qvw.

The event fill a variable with the concatenation of values you selected.

Another event on the first qvw executes the macro when that variable has changed.

Finally an event on the second qvw on variable v1 changing, makes a selection on the same field using concatenated values written in v1.

Regards