Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
brettaustin
New 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
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Straight Table Data Max Filter

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
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Straight Table Data Max Filter

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

Highlighted
kfoudhaily
Contributor III

Re: Straight Table Data Max Filter

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

Highlighted
kfoudhaily
Contributor III

Re: Straight Table Data Max Filter