Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qwebnm
Partner - Creator III
Partner - Creator III

How to set up QlikSense Windows Performance Sheet.

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.

seheon_0-1667369515559.png

 


Thanks & Regards.

Labels (2)
1 Solution

Accepted Solutions
rubenmarin

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.

View solution in original post

3 Replies
rubenmarin

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
Partner - Creator III
Partner - Creator III
Author

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

seheon_1-1667872758825.png

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

seheon_0-1667872731637.png

Thanks & Regards.

 

rubenmarin

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.