Count When: Static Count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Count When: Static Count

Thu, 01 Sep 2016 17:41:49 GMT

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 ?

topic Re: Count When: Static Count in QlikView

Count When: Static Count

Re: Count When: Static Count