Straight Table Data Max Filter

[brettaustin]

Hello Community.  I want to filter a straight table using the 'Max' report date found in the data.  The process will create a new record / Report Date each month.  The user wants to either the selected or 'Current (Max date)' when no field is selected.

See attached for example

Thank you!

Brett

[YoussefBelloum · Accepted solution]

Hi,

Please find attached

I've created a variable MaxReportDate =Max(Report Date)

and used this expression:

=Only({<[Report Date]={'$(MaxReportDate)'}>}[Report Date])

[kfoudhaily]

hello,

depending on the context, this might be usefull too, please see attachement.

I have created a trigger to select in the field [Report Date] the max date when the report is opened

[kfoudhaily]

for your information:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Document_Properties_Trig...