default action for Qlik Sense Dashboard

[mstoler]

Hello,

I like the Sheet Actions but I want to in my Dashboard have the current year selected when the Dashboard is opened and then allow the user to select any year.

I reallly need an On Open Action in Qlik Sense. 

Does this exist in the Nov 2020 Release?

Thanks,

Michael

[joaopaulo_delco]

Hi @mstoler !

         It's very simple to do it. Folow the steps below:

1) Open your dashboard and select the current year.

2) Create a Bookmark.

3) With the right button mouse, define the bookmark as standard.

I hope to help.

[mstoler]

Hello,

The problem is the current year now is 2021. 

It will be 2022 next year. I want this to be dynamic without having to update the Dashboard.

Michael

[Or]

Click the search button for Year, and type in =Year=Max(Year). Confirm this shows the correct year (currently 2021) and then hit the Enter key (don't select the value manually). You can then bookmark the selections and Qlik will remember the formula rather than the value.

[mstoler]

Hello,

It is not the max year because my calendar has 3 years in the future.

I can set it based on a variable, vCurrentYear which I set in my load script.

Is this possible?

Michael

[Or]

Probably. Generally speaking, any time you use a formula in the search field, and then hit enter, then the formula will be remembered rather than the specific selection. I assume =Year=$(vCurrentYear) or something similar would work, but I can't test it at the moment.

[joaopaulo_delco]

Try this:

YearDimension={"=YearDimension=Year(today())"}

[mstoler]

Hello,

Sorry where do I put that?

Michael

[joaopaulo_delco · Accepted solution]

Put this formula on year dimension filter like below