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: 
Anonymous
Not applicable

Count When: Static Count

I'm not sure if this is possible but figured I should ask.

My boss is wanting a static count of Enrollement_Status = 'Open' across each month.

So for example Count only when it's the last day of the current month for all Enrollement_Status = 'Open' and then store as a static result in a chart. Do the same every month(last day) but the following month's counts do not change.

Can this be done? If so, where would one start?

1 Reply
Not applicable
Author

Hi John,

I think what you want is create a chart with

- Date as Dimension

- Anexpression :

=count(DISTINCT if([Start Date Month] <= Date  and [End Date Month] >= Date and Status = 'Open' , Member)) 


is it what you want ?