use a macro to open a qvw and make selections.

[#1]

title says it all,

i want to put a button in a sheet with a macro that will open a document on a certain sheet and make some selections.

does anyone have an example on how to do this?

Thanks

Rick

[#2]

Hi,

You can do it with actions in two steps.

1. Add a button to the sheet and create an action which opens a new qlikview document.

2. In the target document which will be opened on clicking the button, create a bookmark with the default selection values and add an action to call the bookmark when the document is opened.

When you click on the button, the target QVW will be opened and the bookmark with default selection will be called.

-Haneesh

[#3]

Thats brilliant,

however i only want these selctions to be made when the document is accessed through this method.

the document could be opened on its own in which case i wouldnt want these selections to be made.

is there something i can put in the parameters box in the button properties?