Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
brettaustin
Contributor III
Contributor III

Straight Table Data Max Filter

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

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

Please find attached

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

and used this expression:

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

View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

Hi,

Please find attached

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

and used this expression:

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

kfoudhaily
Partner - Creator III
Partner - Creator III

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

QlikView Qlik Sense consultant
kfoudhaily
Partner - Creator III
Partner - Creator III