How to select a period when opening the document or sheet ?

[stephane_kosior]

Hi,

How to select a period of time when opening the  document or sheet ?

Thanks

Stéphane

[Taoufiq_Zarra]

if it's on Qlikview then:

Sheet Properties->Triggers

OnActivateSheet-> Add Actions->Add->Selection->Select in Field

voilà

[sergio0592]

Hi,

You can use Trigger in Doc poperties/Trigger. You ca use On open and  Select in Field actions.

[stephane_kosior]

Thanks but my question was confusing ... I knew the Trigger ... but my question was about the criteria to select the period.

E.g : if I want to get the current month selected how to do that ?

Thanks

Stéphane

[Taoufiq_Zarra]

Maye be :

[stephane_kosior]

Thanks but nothing happens !

[Taoufiq_Zarra]

can you share a sample Data ?

[stephane_kosior]

Sorry it works with your example as I made a mistake usine '=YearMonth' instead of 'YearMonth'

Now great but if I want to use 2 variables (I mean a period between 2 dates)

vStartPeriod = 2020-01-01

vEnd Period = 2020-02-29

Thanks,

Stéphane

[stephane_kosior · Accepted solution]

Found :

='(<='&vEndPeriod&' >='&vStartPeriod&')'

Thanks to all !

Have a good day

Stéphane