Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
Hi,
Do a search for Document Chaining.
Bill
Hi
thanks for sharp reply
can you explain with one example ?
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.
Regards
MR
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