Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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