topic action on document in QlikView

action on document

tizianacaem — Mon, 02 May 2011 14:34:30 GMT

Hi to everybody,

I want to set an action on the opening of the document, that select at the same time YEAR= Year (today()) AND YEAR =Year (today()-1)
Any ideas?

thks

Tiziana

action on document

Mon, 02 May 2011 14:39:45 GMT

Hi Tiziana,

Why Action?

You can also Set in the Menu-> clear-> Set clearstate to these Years you mentioned. May be I am understanding you wrong.

Regards

sravan

action on document

erichshiino — Mon, 02 May 2011 14:49:38 GMT

Go to settings -> document properties -> triggers -> OnOpen -> Add Action

There, Add Selection in Field

Field = Year

Seach String

='(' & YEAR(TODAY()) & '|' & (YEAR(TODAY())-1) & ')'

(including the whole line above)

action on document

tizianacaem — Mon, 02 May 2011 14:53:21 GMT

I did not explained well, sorry.

I mean that I want that these value of years are selected during the opening of the sheet, and not clear.

Regards

Tiziana

action on document

erichshiino — Mon, 02 May 2011 15:01:48 GMT

You mentioned 'Open the document' in the first post. If you need to make this on the sheet, you can go to sheet properties ->Triggers and do the same I mentioned before. The attachment can help

action on document

tizianacaem — Mon, 02 May 2011 15:04:25 GMT

thnk you.. it working correctly!!

Regards

Tiziana