Automatic selection of all month this year incl. the actual

[newqlikie]

Hello,

is it possible to automatically select by opening a QV-worksheet all month of this year beginning from January till to the actual month?

E.g.:

Date of opening the worksheet: 21.07.2011

By opening, it should be selected January till July.

E.g.2:

Date of opening the worksheet: 21.01.2011

By opening, it should be selected January.

E.g.3:

For the actual date (27.09.2011) it should be selected following:

Hopefully someone can help me.

Regards,

NewQlikie

[swuehl · Accepted solution]

Hi,

you could use an action triggered by an OnOpen document event.

Go to document properties, triggers.

Select event OnOpen and action Select / Select in Field.

If your month field is Month and created using month(Date), use

Month

as field name ( as is , no equal sign etc.).

As search string use

='=Month<=month(today())'

(with equal and '= ... '  exactely as given)

This should do the trick.

Regards,

Stefan

[newqlikie]

Hi Stefan,

thank you very much about your solution. This one works perfect.

Enclosed a picture about the solution:

Now I tried to add a second condition to select also the actual year. This is the solution:

Just add a second "selection in field" with following syntax:

='=Jahr=year(max(today())'  -  or with a database-field:

JARECDAT is a field with all dates of the database. (e.g. 20.05.2009; 21.05.2009 till one day before today 27.09.2011)

Thanks again for your help.

[#4]

use this:

=Year(Today())