Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Jordan,
You can try Month(Today() ) in place of max(fiscal month) .
Regards,
Akshaya
Hi Jordan,
You can try Month(Today() ) in place of max(fiscal month) .
Regards,
Akshaya
Success, once again! That immediately made it default to the current month.