topic How to set up QlikSense Windows Performance Sheet. in App Development

How to set up QlikSense Windows Performance Sheet.

qwebnm — Wed, 02 Nov 2022 06:12:06 GMT

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.

Re: How to set up QlikSense Windows Performance Sheet.

rubenmarin — Wed, 02 Nov 2022 08:58:56 GMT

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.

Re: How to set up QlikSense Windows Performance Sheet.

qwebnm — Tue, 08 Nov 2022 02:01:38 GMT

=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.

Re: How to set up QlikSense Windows Performance Sheet.

rubenmarin — Tue, 08 Nov 2022 07:25:03 GMT

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.