Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Expression Max Month

Hello,

 

Im trying to show the result for the expression below only for the maximum month or the last month worth of data. 

([Reporting Period.autoCalendar.YearMonth])=Date

 

=(Count(Worker))
-
(count({<[Assigned Cohort]={'Supervisor','ESS II','OMC I','Extended Leave'}>}
[Worker]))

 

Thank you.

1 Reply
Dalton_Ruer
Support
Support

You are using SET ANALYSIS already so assuming you just need to see example of how to handle dates. Here is 1 good example: https://community.qlik.com/t5/QlikView-App-Dev/Set-Analysis-and-max-date/td-p/1007635

Check out this post which includes a full hands on workshop for Set Analysis and includes dates. https://community.qlik.com/t5/Documents/Hands-on-Set-Analysis-from-the-ground-up/ta-p/1799118