Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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