Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

How to fix a selection field using Macro

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

2 Replies
MVP & Luminary
MVP & Luminary

How to fix a selection field using Macro

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

How to fix a selection field using Macro

Rob,

This problem was solved with your suggestion.

Thanks a lot for your help