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

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

stephane_kosior — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Thanks

Stéphane

Taoufiq_Zarra — Mon, 23 Mar 2020 09:48:23 GMT

if it's on Qlikview then:

Sheet Properties->Triggers

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

voilà

sergio0592 — Mon, 23 Mar 2020 09:52:18 GMT

Hi,

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

stephane_kosior — Mon, 23 Mar 2020 10:06:06 GMT

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 — Mon, 23 Mar 2020 10:09:43 GMT

Maye be :

stephane_kosior — Mon, 23 Mar 2020 10:13:40 GMT

Thanks but nothing happens !

Taoufiq_Zarra — Mon, 23 Mar 2020 10:16:17 GMT

can you share a sample Data ?

stephane_kosior — Mon, 23 Mar 2020 10:21:12 GMT

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 — Mon, 23 Mar 2020 10:27:27 GMT

Found :

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

Thanks to all !

Have a good day

Stéphane