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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I do a date comparision in set analysis

=Sum({$<date#([Hire Date Year],'DD.MM.YYYY')={"<="date#(MonthStart((Addmonths(Today(), -1))), 'DD.MM.YYYY')"}, [ Status]={'Active'}>}[Hours])

make sure they were hired before or equal to the first day of last month and their status is active

0 Replies