BUTTONS

[qlikview979]

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 ?

[mrossoit]

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

MR

[Bill_Britt]

Hi,

Do a search for Document Chaining.

Bill

[qlikview979]

Hi

thanks for sharp reply

can you explain with one example ?

[#5]

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.

[mrossoit]

Regards

MR

[mrossoit]

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

MR