topic Auto selection when activate the sheet in QlikView

Auto selection when activate the sheet

Mon, 26 Mar 2012 13:13:29 GMT

Hi, I am trying to set a trigger that will make an autoselection when acitvate the sheet.

The selection I want to make is all finished months current year. If I example enters the sheet todag (March 26) the correct answer should be 201201 and 201202.

Anyone who can help me?

/Magnus

Auto selection when activate the sheet

Mon, 26 Mar 2012 14:15:53 GMT

Do you have a master calendar table in your load script? This will probably be the cleanest way to do what you want. In the master calendar you can then add a flag for complete months in current year and use a trigger on the sheet to select this flag when the sheet activates.

Cheers,

Emma

Auto selection when activate the sheet

Clever_Anjos — Mon, 26 Mar 2012 17:10:26 GMT

You can use 3 actions

1) "Selection in field" - and selects current month

2) "Selection Excluded"

3) "Selection in field" to select current year