Get current Period based on set analysis

[idodel]

Hello all,

I need to create a filter that does not show the current period, so I want to create it on nprinting based on qlikview set analysis.

I have this data

I have tried this one but with no success:

max({<[ReportDate]={'$(=Today())'}>}PeriodPXFYX)

what measure I need to create in order to solve it.

FOR EXAMPLE: 

I need today to return the value: "P3-FY22" so after create that i can eliminate that data on the report.

Thanks for help

Ido

[idodel]

someone ?

[idodel]

?

[idodel]

can someone have a look ? 🙂