Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
zakpullen
Contributor III
Contributor III

Sheet action to filter date on opening sheet

Hi,

This seems like it should be straightforward, but it's not working for me. I want a latest date to be selected when a particular page is opened. I've added the sheet action as follows.

Capture.JPG

 

The full value is '=Max({1}PDR_ReportDate)'. It works fine in a KPI object, but nothing happens when I use it in the sheet action.

 

Many thanks

Labels (2)
1 Solution

Accepted Solutions
lukas_
Contributor III
Contributor III

Hi,

You should try this : 

=num(max({1}[PDR_ReportDate]))

View solution in original post

2 Replies
lukas_
Contributor III
Contributor III

Hi,

You should try this : 

=num(max({1}[PDR_ReportDate]))

zakpullen
Contributor III
Contributor III
Author

Excellent. Thank you!