topic Re: Select certain year in the list box by using variable in QlikView

Select certain year in the list box by using variable

terezagr — Tue, 07 Jan 2014 12:17:52 GMT

Hi all,

I have this list box where I store data about years:

year

2015/6

2014/5

2013/2

2012/1

I would like the year 2014/5 to be pre-selected for users when they open the application. I have been trying this with some variables, but unfortunately not very successfully.

Do you have any advice how to do this?

Thank you for your advice in advance!

Re: Select certain year in the list box by using variable

maxgro — Tue, 07 Jan 2014 12:24:44 GMT

try to use a trigger at the document level (Settings --> Document Properties --> Triggers) on the OnOpen event and add a Select in Field Action on Year field (search string 2014/5)

Regards

Re: Select certain year in the list box by using variable

Anonymous — Tue, 07 Jan 2014 12:26:55 GMT

Tereza

Do test this early in WebView / AccessPoint Ajax mode as I fear they do not support OnOpen Triggers, even though they work perfectly in the standard Qv Desktop.

Best Regards, Bill

Re: Select certain year in the list box by using variable

MK_QSL — Tue, 07 Jan 2014 12:29:08 GMT

Go to any sheet and right click

Properties

Triggers

OnActiveSheet

AddAction

Add

Selection

Select in Field

Field = Year

SearchString = 2014/5

Re: Select certain year in the list box by using variable

terezagr — Tue, 07 Jan 2014 14:06:59 GMT

Thanks for the advice guys, but it does not work for me. Also at the moment I want the year 2014/5 be pre-selected, but in some point in the future I would like 2015/16 selected etc. So with the roll-over to another year the SearchString would have to be changed, which in my opinion is not the best practice.

I am thinking about having a variable set in my load script, where max(year)-365. Any thoughts on this approach?

Cheers T.

Re: Select certain year in the list box by using variable

peschu123 — Tue, 07 Jan 2014 15:40:01 GMT

Hi TerezaGr,

I'm not sure if this is helpful in your case but I use a document trigger to select a date range.

Settings --> Document Properties --> Triggers --> Document Event triggers --> OnOpen --> Add --> Select in Field...

Field: Date

Search String: ='>=' & weekstart(today(0)) & '<=' & weekend(today(0)+200)

Perhaps it is helpful and you can use it in your scenario.

It works in QV Desktop and Ajax (QV AccessPoint).as well.

Best Regards and I hope its helpful,

Peter

Re: Select certain year in the list box by using variable

maxgro — Wed, 08 Jan 2014 08:13:12 GMT

Thanks for info Bill, I tested it and in Ajax OnOpen doesn't work.

Re: Select certain year in the list box by using variable

Wed, 08 Jan 2014 08:17:17 GMT

Hi evrybody

to use a variable, it is not SELECT in field but "External", "set variable"

best regards

Chris

Re: Select certain year in the list box by using variable

peschu123 — Wed, 08 Jan 2014 08:50:10 GMT

Hi Chris,

in general you are right.

I don't know exactly what T. wants to do, but perhaps it is not neccessary to use a variable. Or the variable can be set during script run and than used in the search expression of the trigger event.

By the way, I didn't saw that maxgro already described what I suggested.