Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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