OnActivateSheet Trigger for Current Month

[Anonymous]

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?

[adityaakshaya · Accepted solution]

Hi Jordan,

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

Regards,

Akshaya

[Anonymous]

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