topic Re: OnActivateSheet Trigger for Current Month in QlikView

OnActivateSheet Trigger for Current Month

Anonymous — Tue, 15 May 2018 21:11:21 GMT

Qlikers,

My team is trying to set up a tab so that it defaults to select the current month's fiscal performance. We have experimented with the OnActivateSheet trigger but the string value isn't working thusfar. Since the string must be dynamic as the current month updates frequently, we don't know which string calculation to use. We tried with the below example but December came back since that is the max value for FiscalMonth. Any ideas how to calculate it so that it returns the current month?

Re: OnActivateSheet Trigger for Current Month

adityaakshaya — Tue, 15 May 2018 22:06:47 GMT

Hi Jordan,

You can try Month(Today() ) in place of max(fiscal month) .

Regards,

Akshaya

Re: OnActivateSheet Trigger for Current Month

Anonymous — Wed, 16 May 2018 15:12:18 GMT

Success, once again! That immediately made it default to the current month.