Combination of categories: 3 having a level 1, and 2 of 3 having a level 2

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years

  2. More than 5 years

  3. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias

Hi Ilias,

1) You create two data element categories (I assume you have already created data element category options). For instance

  a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
  b) Sex ( Male Female)

2) You create a category combination e.g. Malaria Age/Pregnancy + Sex.

  a)Select Age/Pregnancy Category (this should be on top)
  b) select Sex Category

3) Create data set sections (you can have a look at the manual for this if you are not familiar with it)
  a) At this stage you Pregnancy Column will also have Male/Female designations
  b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

···

On 10 Dec 2013, at 19:55, Ilias Dine <ilias.dine@gmail.com> wrote:

Hi,

I'm facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

1. Less than 5 years
2. More than 5 years
3. Pregnant women.

The problem is that the categories "less than 5 years" and "more than 5 years" are in turn divided into sub-categories "Male" and "Female", while the category "Pregnant women" does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,
Ilias
_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

Hi Ilias,
I would be careful about this one. If “Confirmed cases of malaria in pregnant women” is a subset of “Confirmed cases of malaria /> 5 years / Female”, I would not include this as part of a single data element. Here in Zambia, we count “Confirmed cases of malaria /> 5 years / Female” (which might be 50) and then “Confirmed cases of malaria in pregnant women” (which might be 2). However the 2 cases of confirmed malaria in pregnant women are also part of the “Confirmed cases of malaria /> 5 years / Female”. Categorical data elements will automatically total all of the component category options when determining a total, so, the total would include include duplicates. It may work differently in your case, i.e. that pregnant women are not a subset of > 5 years /Female.

You could just create two categories as follows…

  1. Age (<5, > 5 )

  2. Gender (Malaria ) : Male, Non-pregnant female, Pregnant female

Note however, you will end up with a <5 years/Pregnant female, category combo option, which will never be used, but which you can “grey-out” so that data is never entered into to it. This of course assumes that you are collecting the data such that “Non-pregnant” and “Pregnant” females are exclusvie.

The other option (which we use here) is to have two data elements

  1. Number of cases of confirmed malaria (Age:<5/>5, Male/Female)

  2. Number of cases of confirmed malaria in pregnancy (default)

In this case, the second data element is a subset of “Number of cases of confirmed malaria in pregnancy/>5/Female”, so the totals will be correct.

So, it really depends a bit on how the data is collected. Just be sure that the totals will not result in double counting.

Best regards,
Jason

···

On Tue, Dec 10, 2013 at 10:34 PM, Adebusoye Anifalaje busoye@hisp.org wrote:

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi,

Jason is right. I was going to mention that you should be sure that the combining the data elements will not result in double counting. So, not unless pregnant women over 5 years are counted exclusively under the pregnancy data element, you will need to create two different category combinations.

Best

Busoye

···

On Tue, Dec 10, 2013 at 10:34 PM, Adebusoye Anifalaje busoye@hisp.org wrote:

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias

···

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

···

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi,

It is OK for the definition of data elements sections and gray fields, thank you again for the explanation. The problem now is that I can not put in the same data set data elements with combinations of categories and data elements that do not include combinations of categories.

In my case, data elements as the total number of consultations, the total number of malaria cases, etc., are subdivided into categories. But other data elements as the number of pregnant women receiving ITNs or the total number of thick films made in the health center do not have category. I added a section for these items with the value “default” for the combo categories, but there is no field that appears for these data elements in the data entry. Should I create then a separate data element for entering these informations or is there other ways to manage this ?

Thanks again for the help.

Best Regards,

Ilias

···

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Use separate sections.

···

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

It’s what I’ve done. Separate section for each type of category combination. The problem is for data elements that do not have categories combination (e.g. total number of thick films made in the health center which is not subdivided into any category). I’ve used the combination category “default” available in the combo select categories but it doesn’t seem to be the way.

···

2013/12/13 Knut Staring knutst@gmail.com

Use separate sections.

Sent from my mobile

On 13 Dec 2013 02:03, “Ilias Dine” ilias.dine@gmail.com wrote:

Hi,

It is OK for the definition of data elements sections and gray fields, thank you again for the explanation. The problem now is that I can not put in the same data set data elements with combinations of categories and data elements that do not include combinations of categories.

In my case, data elements as the total number of consultations, the total number of malaria cases, etc., are subdivided into categories. But other data elements as the number of pregnant women receiving ITNs or the total number of thick films made in the health center do not have category. I added a section for these items with the value “default” for the combo categories, but there is no field that appears for these data elements in the data entry. Should I create then a separate data element for entering these informations or is there other ways to manage this ?

Thanks again for the help.

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Ilias,

Not sure I understand exactly how you have set up your data elements and data set. I’ll try to explain the rules here and have made a new example on the demo that you can look at.

Each section can have only one category combination. “default” (should perhaps be called “none”) can be considered a category combination so it cannot be combined with another one. This rule is basically there to make sure each section can be rendered as a table with the same number of columns (category option combinations) for each row (data element).

You can of course create multiple sections for each category combination (depending on which data elements that you want to group together.

I have created a test data on the /dev demo server to illustrate.

Go to http://apps.dhis2.org/dev

log in with the admin user

Go to data entry, select Sierra Leone and pick “test data set” and any month.

You’ll see the different sections there. The bottom one called “Delivery” has the “default” category combination.

You can then see how this was defined by going to dataset and sections and data elements in the maintenance part of the system.

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics

University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

On 13 December 2013 06:42, Ilias Dine ilias.dine@gmail.com wrote:

It’s what I’ve done. Separate section for each type of category combination. The problem is for data elements that do not have categories combination (e.g. total number of thick films made in the health center which is not subdivided into any category). I’ve used the combination category “default” available in the combo select categories but it doesn’t seem to be the way.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/13 Knut Staring knutst@gmail.com

Use separate sections.

Sent from my mobile

On 13 Dec 2013 02:03, “Ilias Dine” ilias.dine@gmail.com wrote:

Hi,

It is OK for the definition of data elements sections and gray fields, thank you again for the explanation. The problem now is that I can not put in the same data set data elements with combinations of categories and data elements that do not include combinations of categories.

In my case, data elements as the total number of consultations, the total number of malaria cases, etc., are subdivided into categories. But other data elements as the number of pregnant women receiving ITNs or the total number of thick films made in the health center do not have category. I added a section for these items with the value “default” for the combo categories, but there is no field that appears for these data elements in the data entry. Should I create then a separate data element for entering these informations or is there other ways to manage this ?

Thanks again for the help.

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Ola,

This is what I’ve done. One section grouping data elements having same categories combination. And one section with combination category ‘default’ for data elements not having combination categories. In data entry, all sections appear, even one that has “default” as a categories combination. But for this section only, there is no input field ‘value’ to enter the value. I then tried to modify for this data element its categories combination, and when I do, the input fields appear correctly in the data entry form. I’ve checked the html source and there is no input field there neither.

···

2013/12/13 Ola Hodne Titlestad olati@ifi.uio.no

Hi Ilias,

Not sure I understand exactly how you have set up your data elements and data set. I’ll try to explain the rules here and have made a new example on the demo that you can look at.

Each section can have only one category combination. “default” (should perhaps be called “none”) can be considered a category combination so it cannot be combined with another one. This rule is basically there to make sure each section can be rendered as a table with the same number of columns (category option combinations) for each row (data element).

You can of course create multiple sections for each category combination (depending on which data elements that you want to group together.

I have created a test data on the /dev demo server to illustrate.

Go to http://apps.dhis2.org/dev

log in with the admin user

Go to data entry, select Sierra Leone and pick “test data set” and any month.

You’ll see the different sections there. The bottom one called “Delivery” has the “default” category combination.

You can then see how this was defined by going to dataset and sections and data elements in the maintenance part of the system.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics

University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

On 13 December 2013 06:42, Ilias Dine ilias.dine@gmail.com wrote:

It’s what I’ve done. Separate section for each type of category combination. The problem is for data elements that do not have categories combination (e.g. total number of thick films made in the health center which is not subdivided into any category). I’ve used the combination category “default” available in the combo select categories but it doesn’t seem to be the way.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/13 Knut Staring knutst@gmail.com

Use separate sections.

Sent from my mobile

On 13 Dec 2013 02:03, “Ilias Dine” ilias.dine@gmail.com wrote:

Hi,

It is OK for the definition of data elements sections and gray fields, thank you again for the explanation. The problem now is that I can not put in the same data set data elements with combinations of categories and data elements that do not include combinations of categories.

In my case, data elements as the total number of consultations, the total number of malaria cases, etc., are subdivided into categories. But other data elements as the number of pregnant women receiving ITNs or the total number of thick films made in the health center do not have category. I added a section for these items with the value “default” for the combo categories, but there is no field that appears for these data elements in the data entry. Should I create then a separate data element for entering these informations or is there other ways to manage this ?

Thanks again for the help.

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

I’ve repeated the same test: added a combination category to my data element.
Then on data set page, clicked on “create data entry form”: all “subdivided” data elements are available there for insertion in the form editor, I can see my data element there (ITNs) subdivided into two categories.

After that I removed the combination category for ITNs data element and choosed “default”

Then on data set page, clicked again on “create date entry form”: all “subdivided” data elements are available there for insertion in the form editor, except my ITNs data element that is not present.

···

2013/12/13 Ilias Dine ilias.dine@gmail.com

Hi Ola,

This is what I’ve done. One section grouping data elements having same categories combination. And one section with combination category ‘default’ for data elements not having combination categories. In data entry, all sections appear, even one that has “default” as a categories combination. But for this section only, there is no input field ‘value’ to enter the value. I then tried to modify for this data element its categories combination, and when I do, the input fields appear correctly in the data entry form. I’ve checked the html source and there is no input field there neither.

2013/12/13 Ola Hodne Titlestad olati@ifi.uio.no

Hi Ilias,

Not sure I understand exactly how you have set up your data elements and data set. I’ll try to explain the rules here and have made a new example on the demo that you can look at.

Each section can have only one category combination. “default” (should perhaps be called “none”) can be considered a category combination so it cannot be combined with another one. This rule is basically there to make sure each section can be rendered as a table with the same number of columns (category option combinations) for each row (data element).

You can of course create multiple sections for each category combination (depending on which data elements that you want to group together.

I have created a test data on the /dev demo server to illustrate.

Go to http://apps.dhis2.org/dev

log in with the admin user

Go to data entry, select Sierra Leone and pick “test data set” and any month.

You’ll see the different sections there. The bottom one called “Delivery” has the “default” category combination.

You can then see how this was defined by going to dataset and sections and data elements in the maintenance part of the system.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics

University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

On 13 December 2013 06:42, Ilias Dine ilias.dine@gmail.com wrote:

It’s what I’ve done. Separate section for each type of category combination. The problem is for data elements that do not have categories combination (e.g. total number of thick films made in the health center which is not subdivided into any category). I’ve used the combination category “default” available in the combo select categories but it doesn’t seem to be the way.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/13 Knut Staring knutst@gmail.com

Use separate sections.

Sent from my mobile

On 13 Dec 2013 02:03, “Ilias Dine” ilias.dine@gmail.com wrote:

Hi,

It is OK for the definition of data elements sections and gray fields, thank you again for the explanation. The problem now is that I can not put in the same data set data elements with combinations of categories and data elements that do not include combinations of categories.

In my case, data elements as the total number of consultations, the total number of malaria cases, etc., are subdivided into categories. But other data elements as the number of pregnant women receiving ITNs or the total number of thick films made in the health center do not have category. I added a section for these items with the value “default” for the combo categories, but there is no field that appears for these data elements in the data entry. Should I create then a separate data element for entering these informations or is there other ways to manage this ?

Thanks again for the help.

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

No, there is something not turning round with my case and I don’t understand what. I’ve just removed all data set sections, then checked in “create data entry form” which data elements were available for insertion in the customizable data entry form. And only data elements being subdivided were available there. I’ve even created another data element, just to be sure, and added it to the data set, and it does not appear on the list of available data elements. When changing for this data element its category combination from default to another category combination, it then appears in the list… As if data elements having categories combination and data elements having “default” as categories combination could not gather in my installation.

What can I check in order to understand what’s going wrong ?

···

2013/12/13 Ilias Dine ilias.dine@gmail.com

I’ve repeated the same test: added a combination category to my data element.
Then on data set page, clicked on “create data entry form”: all “subdivided” data elements are available there for insertion in the form editor, I can see my data element there (ITNs) subdivided into two categories.

After that I removed the combination category for ITNs data element and choosed “default”

Then on data set page, clicked again on “create date entry form”: all “subdivided” data elements are available there for insertion in the form editor, except my ITNs data element that is not present.

2013/12/13 Ilias Dine ilias.dine@gmail.com

Hi Ola,

This is what I’ve done. One section grouping data elements having same categories combination. And one section with combination category ‘default’ for data elements not having combination categories. In data entry, all sections appear, even one that has “default” as a categories combination. But for this section only, there is no input field ‘value’ to enter the value. I then tried to modify for this data element its categories combination, and when I do, the input fields appear correctly in the data entry form. I’ve checked the html source and there is no input field there neither.

2013/12/13 Ola Hodne Titlestad olati@ifi.uio.no

Hi Ilias,

Not sure I understand exactly how you have set up your data elements and data set. I’ll try to explain the rules here and have made a new example on the demo that you can look at.

Each section can have only one category combination. “default” (should perhaps be called “none”) can be considered a category combination so it cannot be combined with another one. This rule is basically there to make sure each section can be rendered as a table with the same number of columns (category option combinations) for each row (data element).

You can of course create multiple sections for each category combination (depending on which data elements that you want to group together.

I have created a test data on the /dev demo server to illustrate.

Go to http://apps.dhis2.org/dev

log in with the admin user

Go to data entry, select Sierra Leone and pick “test data set” and any month.

You’ll see the different sections there. The bottom one called “Delivery” has the “default” category combination.

You can then see how this was defined by going to dataset and sections and data elements in the maintenance part of the system.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics

University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

On 13 December 2013 06:42, Ilias Dine ilias.dine@gmail.com wrote:

It’s what I’ve done. Separate section for each type of category combination. The problem is for data elements that do not have categories combination (e.g. total number of thick films made in the health center which is not subdivided into any category). I’ve used the combination category “default” available in the combo select categories but it doesn’t seem to be the way.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/13 Knut Staring knutst@gmail.com

Use separate sections.

Sent from my mobile

On 13 Dec 2013 02:03, “Ilias Dine” ilias.dine@gmail.com wrote:

Hi,

It is OK for the definition of data elements sections and gray fields, thank you again for the explanation. The problem now is that I can not put in the same data set data elements with combinations of categories and data elements that do not include combinations of categories.

In my case, data elements as the total number of consultations, the total number of malaria cases, etc., are subdivided into categories. But other data elements as the number of pregnant women receiving ITNs or the total number of thick films made in the health center do not have category. I added a section for these items with the value “default” for the combo categories, but there is no field that appears for these data elements in the data entry. Should I create then a separate data element for entering these informations or is there other ways to manage this ?

Thanks again for the help.

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

OK. I started from the installation and I was able to add the two types of data elements.

I tried before to compare my setup with that of dhis demo and I found this : in my “category options”, there was not the “default” option. I do not know how this option could disappear from my installation. I remember asking myself at the beginning of what it would serve and I wonder if I did not inadvertently deleted it in the beginning. I tried again to remove it to see if it reproduced my problem but I was unable. Is it possible to know if the option “default” can be accidentally deleted in some cases?

Another thing: in the creation of the data item, is it possible to know why it is not possible to directly add a category with options? Why just only combinations of categories ? I was forced in my case to create categories combinations having only one category in order to be able to use this category.

Thank you again.

Best Regards,

Kader

···

2013/12/13 Ilias Dine ilias.dine@gmail.com

No, there is something not turning round with my case and I don’t understand what. I’ve just removed all data set sections, then checked in “create data entry form” which data elements were available for insertion in the customizable data entry form. And only data elements being subdivided were available there. I’ve even created another data element, just to be sure, and added it to the data set, and it does not appear on the list of available data elements. When changing for this data element its category combination from default to another category combination, it then appears in the list… As if data elements having categories combination and data elements having “default” as categories combination could not gather in my installation.

What can I check in order to understand what’s going wrong ?

2013/12/13 Ilias Dine ilias.dine@gmail.com

I’ve repeated the same test: added a combination category to my data element.
Then on data set page, clicked on “create data entry form”: all “subdivided” data elements are available there for insertion in the form editor, I can see my data element there (ITNs) subdivided into two categories.

After that I removed the combination category for ITNs data element and choosed “default”

Then on data set page, clicked again on “create date entry form”: all “subdivided” data elements are available there for insertion in the form editor, except my ITNs data element that is not present.

2013/12/13 Ilias Dine ilias.dine@gmail.com

Hi Ola,

This is what I’ve done. One section grouping data elements having same categories combination. And one section with combination category ‘default’ for data elements not having combination categories. In data entry, all sections appear, even one that has “default” as a categories combination. But for this section only, there is no input field ‘value’ to enter the value. I then tried to modify for this data element its categories combination, and when I do, the input fields appear correctly in the data entry form. I’ve checked the html source and there is no input field there neither.

2013/12/13 Ola Hodne Titlestad olati@ifi.uio.no

Hi Ilias,

Not sure I understand exactly how you have set up your data elements and data set. I’ll try to explain the rules here and have made a new example on the demo that you can look at.

Each section can have only one category combination. “default” (should perhaps be called “none”) can be considered a category combination so it cannot be combined with another one. This rule is basically there to make sure each section can be rendered as a table with the same number of columns (category option combinations) for each row (data element).

You can of course create multiple sections for each category combination (depending on which data elements that you want to group together.

I have created a test data on the /dev demo server to illustrate.

Go to http://apps.dhis2.org/dev

log in with the admin user

Go to data entry, select Sierra Leone and pick “test data set” and any month.

You’ll see the different sections there. The bottom one called “Delivery” has the “default” category combination.

You can then see how this was defined by going to dataset and sections and data elements in the maintenance part of the system.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics

University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

On 13 December 2013 06:42, Ilias Dine ilias.dine@gmail.com wrote:

It’s what I’ve done. Separate section for each type of category combination. The problem is for data elements that do not have categories combination (e.g. total number of thick films made in the health center which is not subdivided into any category). I’ve used the combination category “default” available in the combo select categories but it doesn’t seem to be the way.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/13 Knut Staring knutst@gmail.com

Use separate sections.

Sent from my mobile

On 13 Dec 2013 02:03, “Ilias Dine” ilias.dine@gmail.com wrote:

Hi,

It is OK for the definition of data elements sections and gray fields, thank you again for the explanation. The problem now is that I can not put in the same data set data elements with combinations of categories and data elements that do not include combinations of categories.

In my case, data elements as the total number of consultations, the total number of malaria cases, etc., are subdivided into categories. But other data elements as the number of pregnant women receiving ITNs or the total number of thick films made in the health center do not have category. I added a section for these items with the value “default” for the combo categories, but there is no field that appears for these data elements in the data entry. Should I create then a separate data element for entering these informations or is there other ways to manage this ?

Thanks again for the help.

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/11 Jason Pickering jason.p.pickering@gmail.com

Hi Ilias,

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

I was not really taking a position on it one way or the other, just to make you aware of the fact that you should not use categorical data elements (except very carefully) for data elements whose categories do not add to a total. If the reporting system is collecting the data that way (meaning pregnant women are excluded from Female/>5 years) then category options will work fine. But if the reporting system is not, that is the case you need to be careful with.

The extreme case of this is with logistics data elements, which are disaggregated by things like “Quantity ordered”, “Quantity received”, and many other category options. If you have several hundred (or thousand) of commodities, creating each and every “default” data element is rather painful and inefficient. Using the option for “Skip category total in reports” in the category combination may be more appropriate for these types of data elements, where the category options do not add to a total. You may then need to use other methods (indicators or SQL or whatever) to calculate “Totals”.

Regards,

Jason

On Wed, Dec 11, 2013 at 4:03 PM, Ilias Dine ilias.dine@gmail.com wrote:

Hi Adebusoye,

I understand the logic. The combination of categories created must have been associated first with the data element. And there’s actually the possibility to enable or disable columns in section grey field… Thank you, it makes it possible to handle this case. I guess it is not possible to merge the two columns “sex” and that it is essential to choose a type of sex for pregnant women in section grey field. I then added a third option for sex category that I called “Sex Not Applicable” and repeated the same procedure. Except that: 1) I disable “Sex Not Applicable” for < 5 Yrs and > 5 Yrs and 2) I disable “Male” and “Female” for Pregnant Women. I will see what is the most obvious to use with data entry and data processing.

Jason is actually right : Pregnant women should not be counted in > 5 Yrs. I’ll pay attention to this.

Kind Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/10 Adebusoye Anifalaje busoye@hisp.org

Hi Ilias,

  1. You create two data element categories (I assume you have already created data element category options). For instance

     a) Age/Pregnancy (< 5 Yrs; > 5 Yrs and Pregnant Women)
    
     b) Sex ( Male Female)
    
  2. You create a category combination e.g. Malaria Age/Pregnancy + Sex.

     a)Select Age/Pregnancy Category (this should be on top)
    
     b) select Sex Category
    
  3. Create data set sections (you can have a look at the manual for this if you are not familiar with it)

     a) At this stage you Pregnancy Column will also have Male/Female designations
    
     b) Use the Section Grey Field Management option to disable the Male column from Pregnancy.
    

If you are still unclear about how to go about any of the steps, I will be happy to help clarify.

Regards,

Busoye

On 10 Dec 2013, at 19:55, Ilias Dine ilias.dine@gmail.com wrote:

Hi,

I’m facing this problem with the definition of categories of a data element. It is the total number of confirmed cases of malaria which is in our system divided into 3 categories :

  1. Less than 5 years
  1. More than 5 years
  1. Pregnant women.

The problem is that the categories “less than 5 years” and “more than 5 years” are in turn divided into sub-categories “Male” and “Female”, while the category “Pregnant women” does not have this subdivision.

Is there a way to handle this situation ?

Best Regards,

Ilias


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi @jason,

Many years have gone by since this was posted, but would you give further clarification between categorical data elements and data elements with category combination?

Thanks