topic Set default selections when opening .qvw in QlikView

Set default selections when opening .qvw

Thu, 05 Feb 2015 23:38:42 GMT

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?

Re: Set default selections when opening .qvw

Fri, 06 Feb 2015 00:19:40 GMT

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

avinashelite — Fri, 06 Feb 2015 04:28:35 GMT

Hi Bernard,

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

Re: Set default selections when opening .qvw

Thu, 28 May 2015 11:34:52 GMT

Hi,

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

Re: Set default selections when opening .qvw

Thu, 28 May 2015 13:56:38 GMT

Hi Berth,

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

Here, you need to add the fields.