Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Set default selections when opening .qvw

HI,

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?

4 Replies
Not applicable

Re: Set default selections when opening .qvw

Bernard,

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.

Re: Set default selections when opening .qvw

Hi Bernard,

Set the trigger on all the regions year and month that will do , if you facing any issue please post the app

Not applicable

Re: Set default selections when opening .qvw

Hi,

How to select two years, say current year and previous year on open/on activationof a sheet.?

Not applicable

Re: Set default selections when opening .qvw

Hi Berth,

Go to document properties-->select triggres tab-->Document event triggers-->On open (has actions).

Here, you need to add the fields.