Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to fix a selection field using Macro

How I can to fix a selection field automatically when I open a QVD Sheet?

It exists some Macro or specific instructions?

Thanks

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Any selections in force when the document is saved will still be selected when the document is opened again -- even after reload. This works fine for static selections.

If you need to make dynamic selections, such as today's date, you'll need to use a macro assigned to the Document OnOpen event. An example is available in the QV Cookbook at:
http://www.robwunderlich.com/Download.html
The specific example is titled "Making initial selections on document open"

-Rob

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Any selections in force when the document is saved will still be selected when the document is opened again -- even after reload. This works fine for static selections.

If you need to make dynamic selections, such as today's date, you'll need to use a macro assigned to the Document OnOpen event. An example is available in the QV Cookbook at:
http://www.robwunderlich.com/Download.html
The specific example is titled "Making initial selections on document open"

-Rob

Not applicable
Author

Rob,

This problem was solved with your suggestion.

Thanks a lot for your help