I hope someone can guide me. I have a qlikview document with list boxes for year, month, date, region. I want to document to open by default on all regions for the current year and month. I read and tried several trigger actions, but none of them seem to work. Can anyone suggest how I can gt this to work?
Probably the easiest way to do this would be to Go to Settings - Document Properties - Triggers and then for Document Event Trigger select ON Open and click Edit Actions. Once here you will click Add and then Action Type of Selection with Action of Select In Field. Then your field will be the names of your Year or Month Fields and the Search String will be =Month(Monthstart( Today( ) ) ) or =Year(Yearstart( Today( ) ) ) where the onth or year equals your field names. Below is screenshot of setting and I tested this on my document and it worked just fine.