Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
idodel
Contributor III
Contributor III

Get current Period based on set analysis

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

idodel_0-1627467481740.png

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

 

3 Replies
idodel
Contributor III
Contributor III
Author

someone ?

idodel
Contributor III
Contributor III
Author

?

idodel
Contributor III
Contributor III
Author

can someone have a look ? 🙂