How to set up QlikSense Windows Performance Sheet.

[qwebnm]

When I click on the QlikSense Windows Performance Sheet, I want to show the date with Max(date) selected by default.

How should I set it up?
Is it very difficult?

Please answer.

Thanks & Regards.

[rubenmarin1 · Accepted solution]

Hi, try following this thread: https://community.qlik.com/t5/App-Development/Default-Selection-of-Max-Date/m-p/1662582

So try adding a table or filter with the Date field, use the filter opton of that object and filter using =Date=Max({1}TOTAL Date), press enter, create a bookmark with this selection and set it as the default bookmark.

[qwebnm]

=Date=Max({1} total Date)
Putting the above values into the expression, today's date (2022-11-08) comes out.

=Date=Max({1} total Date) should appear in the bookmark, but today's date (2022-1-11-08) is still entered in the bookmark.
How can I put the script?

Tried a lot but it's the same.
Help me.

Thanks & Regards.

[rubenmarin1]

To keep the formula in the filter you need to follow the steps: So try adding a table or filter with the Date field (just the Date field as dimension, without any expression), use the filter option of that object and filter using =Date=Max({1}TOTAL Date), press enter.

If you use an expression you will select the already calculated value, not the formula.