topic how to set default selection in QlikView

how to set default selection

Tue, 10 Apr 2012 11:16:28 GMT

I would like to know how to set default selection in sheet object. ie. when we first login, the max(year) should be selected by default.

Thanks.

how to set default selection

Tue, 10 Apr 2012 11:24:35 GMT

Hi,

Go to Settings -> Document Properties -> Triggers

Select the “OnOpen” trigger and press “Add Action”

Add the Select in Field Trigger (section Selection)

Field: year

Search String: = max(year)

Hth,

Thilo

how to set default selection

adhudson — Wed, 11 Apr 2012 04:29:06 GMT

Hi,

I am assuming that you have the year field as a selection criteria and it appears as a list box.

So now, goto the list box properties and select "Always one selected value" in general tab of the list box properties.

Regards

Andrew Hudson

how to set default selection

Wed, 11 Apr 2012 05:00:17 GMT

Hi,

If you want max(year) or any other year selected in that field to stay selected even if you press selcted then go by Andews's way but if you want that when you press clear year should be cleared also. Then, go by triggers way as Thilo suggested.

One thing to note here is that if you go by Always one selected value as suggested by Andrew then you will never be able to select more than one year. (for example you can not select 2010 and 2011 both).

So, it all depends your requirement but always one selected mode should be preferred over triggers.

Ashutosh

how to set default selection

Thu, 12 Apr 2012 00:44:07 GMT

Thanks for your detailed explination. See what i am thinking is i can not use "onOpen" trigger, because 1st timelogin that is fine with trigger, but if I am playing on different tabs and comeback to dashboard , then the trigger will reset my year selection to max(year) insted of keeping my selection from different tab. I did not know how Andrew option works because "Always one selected value" is disable for this list box in my case.

See all i need this selection only 1st time login. So i am thinking of set this when login only. so after login and play with different sheets and still maintain the year selection across the sheets.

Is there any way i can incorporate this trigger or some thing during the authientacation.

Thanks.

how to set default selection

Thu, 12 Apr 2012 04:21:00 GMT

Hi,

Always one selcted is not disabled for your liast box. You first select any one value then go to list box properties and then it will be available.

Also, for your requirement on open trigger should work fine because it is not dependent on tabs, so if you go to different tab, do some selections and come back to first tab it will not change your selections. This behavior is of on Activate sheet trigger.

On Open trigger will work when the application is opened by the user. So, a user opens an application then this trigger will run and select max(year) in your year field but then it will not run for his entire session. Then again user closes the application and next time it again opnes then it will again run the trigger.

Hope this makes sense.

Ashutosh

Re: how to set default selection

Anonymous — Thu, 12 Apr 2012 05:47:56 GMT

Hope the attached file will be solve your problem.

Settings-->Document Properties-->Triggers-->DocumentEventTriggers--->OnOpen--->add action-->Select in Field ( Field --> year , Value-->Max(Year))

Regards

Ashok

Re: how to set default selection

Fri, 28 Sep 2012 05:11:27 GMT

Hi,

I am using 2 Triggers for it 1 for max(Year) and 2 for max(Month).

But my max(Year) is 2012 and max(Month) in 2012 is Aug. and not Dec.

When I open my document it is showing data where max(Year)=2012 & max(Month)=Dec

I checked this using text objects. But in actual it should show me 2012 Aug data right?

Can you please help me regarding this?

- Yojas

Re: how to set default selection

hkapadia — Wed, 30 Jul 2014 21:36:36 GMT

I was looking for the similar thing & did what was mentioned here & it worked for me.

Thank you all for providing the direction.

Re: how to set default selection

Anonymous — Wed, 30 Sep 2015 17:58:27 GMT

Is there a way to select more that one value in a drop down using this method?

Re: how to set default selection

Sat, 14 Nov 2015 09:12:00 GMT

Default selections can be made by using Document Bookmarks and using triggers combined easily.

1.Make selections -> Add Bookmark(save as document bookmark) Note Bookmark ID

2.Sheet Properties-> Triggers-> Activate-> Bookmarks--> provide above Bookmark ID.

works like charm.

You can do that same for Document level triggers.

Hope this helps.