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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mashikoo
Contributor
Contributor

Daily enrollments and Daily Checkins

I have a dimension and 2 measures. The dimension is date while the measures are enrollments and checkins. Below is the expression I am using for both Enrollments and Checkins but it keeps giving me the total count and not the daily count. 

 

=Sum({$< Date={"$(=Date(Max(Date),'MM/DD/YYYY'))"}>} [Enrollments])

=Sum({$< Date={"$(=Date(Max(Date),'MM/DD/YYYY'))"}>} [CheckIns])

Please help!!

Labels (6)
10 Replies
mashikoo
Contributor
Contributor
Author

mashikoo_1-1654617147109.png