topic Re: Straight Table Data Max Filter in QlikView

Straight Table Data Max Filter

brettaustin — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Straight Table Data Max Filter

YoussefBelloum — Mon, 02 Jul 2018 13:07:16 GMT

Hi,

Please find attached

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

and used this expression:

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

Re: Straight Table Data Max Filter

kfoudhaily — Mon, 02 Jul 2018 14:00:49 GMT

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

Re: Straight Table Data Max Filter

kfoudhaily — Mon, 02 Jul 2018 14:02:05 GMT

for your information:

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