Is possible to have always a value of date selected and set the max date as default?

[aster5]

I want that a unique value of date is selected and set the max date as default when the app is opened. But the interaction between this two issues does not seem to work well. Anyone knows how could I do it?

Thank you in advance

[Zapparoli]

Hi Aster,

It is possible with a bit of a trick when creating the bookmark. You basically makes a Expression as a bookmark instead of a fixed value, here is how:

First, create a Max(Date) Measure, Like so:

=Max({<[Created Date] = {"$(=Max([Created Date]))"}>} [Created Date])

Put this measure on a KPI changing the dimension for your own like so:

With this out of the way, now create a filter pane with the same Dimension, and on the search bar paste the same expression you used. (Don't forget about the "=" on the start)

Now here is the fun part DON'T click on the value, but press ENTER, this will make sure that on your current filter we have the EXPRESSION, not the value.

After this simply create a bookmark and see the results:

You can set this bookmark a default, whenever you open the app, your Maximum date (Or Month if you want) will be filtered down.

So when I refresh the App: 

Hope this helps.

-Zapparoli

[Albert_Candelario]

If using QlikView you could achieve this by the triggers at app level or sheet level depending on your requirements.

Cheers,

Albert