Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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 ? 🙂