Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
mrjohn23
Contributor III

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

Re: Count When: Static Count

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 ?