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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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