# How to find total patients enrolled in a program

**URL:** <https://community.dhis2.org/t/how-to-find-total-patients-enrolled-in-a-program/3870>\
**Category:** Support - Assistance technique\
**Created:** [30 October 2016 12:09 UTC](https://community.dhis2.org/t/how-to-find-total-patients-enrolled-in-a-program/3870 "2016-10-30T12:09:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonia](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/antonia/32/42782_2.png) [@antonia](https://community.dhis2.org/u/antonia)\
**Post date:** [30 October 2016 12:09 UTC](https://community.dhis2.org/t/how-to-find-total-patients-enrolled-in-a-program/3870/1 "2016-10-30T12:09:18Z")

</div>

I do this using Event Report table, specifying only the “Program name” and “Events” as Output type. I do this for every org unit ina orgunit group I need, but you can specify also the root of the org unit tree or put the OrgUnit dimention in the Filter (from the Layout tab):

![image](https://dhis2.b-cdn.net/images/transparent.png)

I hope this is what you needed.

Regards

Antonia

> **···**
>
> 2016-10-30 12:06 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > 
> 
> > ​Hello everyone,
> 
> > 
> 
> > I use programs to capture data of chronic disease patients (TEI is a patient).
> 
> > So I have programs defined for Hypertension, Diabetes, Asthma etc.
> 
> > Patients enroll when they are diagnosed with a disease and exit when they either move out of the location or when they die.
> 
> > 
> 
> > ​s there a way to find out total number of patients enrolled in a particular program​ at a particular time?
> 
> > II need this number to find the prevalence rate of the disease ​of a location  
> > ​.​
> 
> > I tried defining program indicator  
> > ​s​
> 
> > using the variables v{tei\_count}, v{enrollment\_count}  
> > ​ but they do not show the total entities currently enrolled in a program . If there is no such variable to get this number, is there any other way to generate the prevalence rate?
> 
> > 
> 
> > Thanks in advance,
> 
> > Arun Paul
> 
> > 
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
> 
> [www.informa.pro](http://www.informa.pro/) - \*Seguici su \*[LinkedIn](https://www.linkedin.com/company/informapro)
> 
> INFORMAPRO S.r.l. - via Luigi Rava 43, Rome 00149 , Italy  
> tel. +39 06 5758926, fax +39 06 62207168, P.IVA IT08095781004
> 
> Skype: informa\_antonia.bezenchek  
> Eng. Antonia Bezenchek - CIO - ICT Engineer

---

<div class="post-metadata">

**Author:** ![Arun\_Paul](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/arun_paul/32/32893_2.png) [@Arun\_Paul](https://community.dhis2.org/u/Arun_Paul)\
**Post date:** [3 December 2016 13:37 UTC](https://community.dhis2.org/t/how-to-find-total-patients-enrolled-in-a-program/3870/2 "2016-12-03T13:37:26Z")

</div>

Hello Antonia,

Thanks for responding.

My problem is how to find out the number of people who are currently enrolled in a program.

I still can’t figure it out. Let me know if you find a way to do it.

Thanks in advance.

- Arun Paul

![image](https://dhis2.b-cdn.net/images/transparent.png)

> **···**
>
> On Sun, Oct 30, 2016 at 5:39 PM, Antonia - Pro [antonia@informa.pro](mailto:antonia@informa.pro) wrote:
> 
> > I do this using Event Report table, specifying only the “Program name” and “Events” as Output type. I do this for every org unit ina orgunit group I need, but you can specify also the root of the org unit tree or put the OrgUnit dimention in the Filter (from the Layout tab):
> 
> > 
> 
> > 
> 
> > I hope this is what you needed.
> 
> > 
> 
> > Regards
> 
> > Antonia
> 
> [www.informa.pro](http://www.informa.pro/) - \*Seguici su \*[LinkedIn](https://www.linkedin.com/company/informapro)
> 
> INFORMAPRO S.r.l. - via Luigi Rava 43, Rome 00149 , Italy  
> tel. +39 06 5758926, fax +39 06 62207168, P.IVA IT08095781004
> 
> Skype: informa\_antonia.bezenchek  
> Eng. Antonia Bezenchek - CIO - ICT Engineer
> 
> 2016-10-30 12:06 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > 
> 
> > ​Hello everyone,
> 
> > 
> 
> > I use programs to capture data of chronic disease patients (TEI is a patient).
> 
> > So I have programs defined for Hypertension, Diabetes, Asthma etc.
> 
> > Patients enroll when they are diagnosed with a disease and exit when they either move out of the location or when they die.
> 
> > 
> 
> > ​s there a way to find out total number of patients enrolled in a particular program​ at a particular time?
> 
> > II need this number to find the prevalence rate of the disease ​of a location  
> > ​.​
> 
> > I tried defining program indicator  
> > ​s​
> 
> > using the variables v{tei\_count}, v{enrollment\_count}  
> > ​ but they do not show the total entities currently enrolled in a program . If there is no such variable to get this number, is there any other way to generate the prevalence rate?
> 
> > 
> 
> > Thanks in advance,
> 
> > Arun Paul
> 
> > 
> 
> > 
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

---

<div class="post-metadata">

**Author:** ![Pepe\_Ken\_Mvulu](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/pepe_ken_mvulu/32/29045_2.png) [@Pepe\_Ken\_Mvulu](https://community.dhis2.org/u/Pepe_Ken_Mvulu)\
**Post date:** [3 December 2016 15:01 UTC](https://community.dhis2.org/t/how-to-find-total-patients-enrolled-in-a-program/3870/3 "2016-12-03T15:01:05Z")

</div>

Hi Arun,  
Can you create a program indicator for this program

In the Agregation type, put **Count**

In the Expression, put **V{tei\_count}**

In the filter, put, The **obligatory attribute or dataelement different of zero** (example. **#{tbLC6IHktf0.spWKINz7xwF} != 0** )

You can **see the report in pivot table**

Regards !

![image](https://dhis2.b-cdn.net/images/transparent.png)

> **···**
>
> 2016-12-03 14:37 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > Hello Antonia,
> 
> > 
> 
> > Thanks for responding.
> 
> > 
> 
> > My problem is how to find out the number of people who are currently enrolled in a program.
> 
> > I still can’t figure it out. Let me know if you find a way to do it.
> 
> > 
> 
> > Thanks in advance.
> 
> > 
> 
> > - Arun Paul
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
> 
> Pepe Ken Mvulu  
> Responsable M&E  
> Programme Village Assaini  
> Direction de l’Hygiène  
> Ministère de la Santé Publique/RDC  
> Tél: +243 811515878  
> Skype: pepe.ken.mvulu
> 
> On Sun, Oct 30, 2016 at 5:39 PM, Antonia - Pro [antonia@informa.pro](mailto:antonia@informa.pro) wrote:
> 
> > I do this using Event Report table, specifying only the “Program name” and “Events” as Output type. I do this for every org unit ina orgunit group I need, but you can specify also the root of the org unit tree or put the OrgUnit dimention in the Filter (from the Layout tab):
> 
> > 
> 
> > 
> 
> > I hope this is what you needed.
> 
> > 
> 
> > Regards
> 
> > Antonia
> 
> [www.informa.pro](http://www.informa.pro/) - \*Seguici su \*[LinkedIn](https://www.linkedin.com/company/informapro)
> 
> INFORMAPRO S.r.l. - via Luigi Rava 43, Rome 00149 , Italy  
> tel. +39 06 5758926, fax +39 06 62207168, P.IVA IT08095781004
> 
> Skype: informa\_antonia.bezenchek  
> Eng. Antonia Bezenchek - CIO - ICT Engineer
> 
> 2016-10-30 12:06 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > 
> 
> > ​Hello everyone,
> 
> > 
> 
> > I use programs to capture data of chronic disease patients (TEI is a patient).
> 
> > So I have programs defined for Hypertension, Diabetes, Asthma etc.
> 
> > Patients enroll when they are diagnosed with a disease and exit when they either move out of the location or when they die.
> 
> > 
> 
> > ​s there a way to find out total number of patients enrolled in a particular program​ at a particular time?
> 
> > II need this number to find the prevalence rate of the disease ​of a location  
> > ​.​
> 
> > I tried defining program indicator  
> > ​s​
> 
> > using the variables v{tei\_count}, v{enrollment\_count}  
> > ​ but they do not show the total entities currently enrolled in a program . If there is no such variable to get this number, is there any other way to generate the prevalence rate?
> 
> > 
> 
> > Thanks in advance,
> 
> > Arun Paul
> 
> > 
> 
> > 
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

---

<div class="post-metadata">

**Author:** ![Arun\_Paul](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/arun_paul/32/32893_2.png) [@Arun\_Paul](https://community.dhis2.org/u/Arun_Paul)\
**Post date:** [3 December 2016 16:09 UTC](https://community.dhis2.org/t/how-to-find-total-patients-enrolled-in-a-program/3870/4 "2016-12-03T16:09:01Z")

</div>

Hi Pepe,

Thanks for responding.

I tried as you suggested, but it’s only giving me count of events satisfying the filter criteria.

What I am interested is to count the number of tracked entity instances enrolled into that program.

I am using version 2.23

Not sure if this is a bug. I found this thread relevant [https://lists.launchpad.net/dhis2-users/msg10869.html](https://lists.launchpad.net/dhis2-users/msg10869.html)

Also tried V{enrollment\_count}. The results are no different.

Thanks,

Arun Paul

![image](https://dhis2.b-cdn.net/images/transparent.png)

> **···**
>
> On Sat, Dec 3, 2016 at 8:31 PM, Pepe Ken Mvulu [pepekento1@gmail.com](mailto:pepekento1@gmail.com) wrote:
> 
> > Hi Arun,  
> > Can you create a program indicator for this program
> 
> > In the Agregation type, put **Count**
> 
> > In the Expression, put **V{tei\_count}**
> 
> > In the filter, put, The **obligatory attribute or dataelement different of zero** (example. **#{tbLC6IHktf0.spWKINz7xwF} != 0** )
> 
> > 
> 
> > You can **see the report in pivot table**
> 
> > 
> 
> > Regards !
> 
> Pepe Ken Mvulu  
> Responsable M&E  
> Programme Village Assaini  
> Direction de l’Hygiène  
> Ministère de la Santé Publique/RDC  
> Tél: +243 811515878  
> Skype: pepe.ken.mvulu
> 
> 2016-12-03 14:37 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > Hello Antonia,
> 
> > 
> 
> > Thanks for responding.
> 
> > 
> 
> > My problem is how to find out the number of people who are currently enrolled in a program.
> 
> > I still can’t figure it out. Let me know if you find a way to do it.
> 
> > 
> 
> > Thanks in advance.
> 
> > 
> 
> > - Arun Paul
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
> 
> On Sun, Oct 30, 2016 at 5:39 PM, Antonia - Pro [antonia@informa.pro](mailto:antonia@informa.pro) wrote:
> 
> > I do this using Event Report table, specifying only the “Program name” and “Events” as Output type. I do this for every org unit ina orgunit group I need, but you can specify also the root of the org unit tree or put the OrgUnit dimention in the Filter (from the Layout tab):
> 
> > 
> 
> > 
> 
> > I hope this is what you needed.
> 
> > 
> 
> > Regards
> 
> > Antonia
> 
> [www.informa.pro](http://www.informa.pro/) - \*Seguici su \*[LinkedIn](https://www.linkedin.com/company/informapro)
> 
> INFORMAPRO S.r.l. - via Luigi Rava 43, Rome 00149 , Italy  
> tel. +39 06 5758926, fax +39 06 62207168, P.IVA IT08095781004
> 
> Skype: informa\_antonia.bezenchek  
> Eng. Antonia Bezenchek - CIO - ICT Engineer
> 
> 2016-10-30 12:06 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > 
> 
> > ​Hello everyone,
> 
> > 
> 
> > I use programs to capture data of chronic disease patients (TEI is a patient).
> 
> > So I have programs defined for Hypertension, Diabetes, Asthma etc.
> 
> > Patients enroll when they are diagnosed with a disease and exit when they either move out of the location or when they die.
> 
> > 
> 
> > ​s there a way to find out total number of patients enrolled in a particular program​ at a particular time?
> 
> > II need this number to find the prevalence rate of the disease ​of a location  
> > ​.​
> 
> > I tried defining program indicator  
> > ​s​
> 
> > using the variables v{tei\_count}, v{enrollment\_count}  
> > ​ but they do not show the total entities currently enrolled in a program . If there is no such variable to get this number, is there any other way to generate the prevalence rate?
> 
> > 
> 
> > Thanks in advance,
> 
> > Arun Paul
> 
> > 
> 
> > 
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

---

<div class="post-metadata">

**Author:** ![Arun\_Paul](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/arun_paul/32/32893_2.png) [@Arun\_Paul](https://community.dhis2.org/u/Arun_Paul)\
**Post date:** [3 December 2016 16:19 UTC](https://community.dhis2.org/t/how-to-find-total-patients-enrolled-in-a-program/3870/5 "2016-12-03T16:19:09Z")

</div>

One more question: As a workaround I was thinking to count the events with a really long time period.

For example: I have a intake stage that is filled soon after a patient is enrolled into the program and an exit stage that is filled just before the patient completes the program.

if I count the number of intake and exits events generated in the last 25 years, that will give me the total membership in the program (intake-exit). Is it possible to define a long time period in the reports?

Thanks,

Arun Paul

![image](https://dhis2.b-cdn.net/images/transparent.png)

> **···**
>
> On Sat, Dec 3, 2016 at 9:39 PM, Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com) wrote:
> 
> > Hi Pepe,
> 
> > 
> 
> > Thanks for responding.
> 
> > 
> 
> > I tried as you suggested, but it’s only giving me count of events satisfying the filter criteria.
> 
> > What I am interested is to count the number of tracked entity instances enrolled into that program.
> 
> > I am using version 2.23
> 
> > Not sure if this is a bug. I found this thread relevant [https://lists.launchpad.net/dhis2-users/msg10869.html](https://lists.launchpad.net/dhis2-users/msg10869.html)
> 
> > 
> 
> > Also tried V{enrollment\_count}. The results are no different.
> 
> > 
> 
> > 
> 
> > 
> 
> > Thanks,
> 
> > Arun Paul
> 
> Cheers,
> 
> - Arun Paul
> 
> On Sat, Dec 3, 2016 at 8:31 PM, Pepe Ken Mvulu [pepekento1@gmail.com](mailto:pepekento1@gmail.com) wrote:
> 
> > Hi Arun,  
> > Can you create a program indicator for this program
> 
> > In the Agregation type, put **Count**
> 
> > In the Expression, put **V{tei\_count}**
> 
> > In the filter, put, The **obligatory attribute or dataelement different of zero** (example. **#{tbLC6IHktf0.spWKINz7xwF} != 0** )
> 
> > 
> 
> > You can **see the report in pivot table**
> 
> > 
> 
> > Regards !
> 
> Pepe Ken Mvulu  
> Responsable M&E  
> Programme Village Assaini  
> Direction de l’Hygiène  
> Ministère de la Santé Publique/RDC  
> Tél: +243 811515878  
> Skype: pepe.ken.mvulu
> 
> 2016-12-03 14:37 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > Hello Antonia,
> 
> > 
> 
> > Thanks for responding.
> 
> > 
> 
> > My problem is how to find out the number of people who are currently enrolled in a program.
> 
> > I still can’t figure it out. Let me know if you find a way to do it.
> 
> > 
> 
> > Thanks in advance.
> 
> > 
> 
> > - Arun Paul
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
> 
> On Sun, Oct 30, 2016 at 5:39 PM, Antonia - Pro [antonia@informa.pro](mailto:antonia@informa.pro) wrote:
> 
> > I do this using Event Report table, specifying only the “Program name” and “Events” as Output type. I do this for every org unit ina orgunit group I need, but you can specify also the root of the org unit tree or put the OrgUnit dimention in the Filter (from the Layout tab):
> 
> > 
> 
> > 
> 
> > I hope this is what you needed.
> 
> > 
> 
> > Regards
> 
> > Antonia
> 
> [www.informa.pro](http://www.informa.pro/) - \*Seguici su \*[LinkedIn](https://www.linkedin.com/company/informapro)
> 
> INFORMAPRO S.r.l. - via Luigi Rava 43, Rome 00149 , Italy  
> tel. +39 06 5758926, fax +39 06 62207168, P.IVA IT08095781004
> 
> Skype: informa\_antonia.bezenchek  
> Eng. Antonia Bezenchek - CIO - ICT Engineer
> 
> 2016-10-30 12:06 GMT+01:00 Arun Paul [paul.arun@gmail.com](mailto:paul.arun@gmail.com):
> 
> > 
> 
> > ​Hello everyone,
> 
> > 
> 
> > I use programs to capture data of chronic disease patients (TEI is a patient).
> 
> > So I have programs defined for Hypertension, Diabetes, Asthma etc.
> 
> > Patients enroll when they are diagnosed with a disease and exit when they either move out of the location or when they die.
> 
> > 
> 
> > ​s there a way to find out total number of patients enrolled in a particular program​ at a particular time?
> 
> > II need this number to find the prevalence rate of the disease ​of a location  
> > ​.​
> 
> > I tried defining program indicator  
> > ​s​
> 
> > using the variables v{tei\_count}, v{enrollment\_count}  
> > ​ but they do not show the total entities currently enrolled in a program . If there is no such variable to get this number, is there any other way to generate the prevalence rate?
> 
> > 
> 
> > Thanks in advance,
> 
> > Arun Paul
> 
> > 
> 
> > 
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
