← Back to team overview

dhis2-users team mailing list archive

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

 

Use separate sections.

Sent from my mobile
On 13 Dec 2013 02:03, "Ilias Dine" <ilias.dine@xxxxxxxxx> 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
>
>
> 2013/12/11 Jason Pickering <jason.p.pickering@xxxxxxxxx>
>
>> 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@xxxxxxxxx> 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
>>>
>>>
>>> 2013/12/10 Adebusoye Anifalaje <busoye@xxxxxxxx>
>>>
>>>> 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@xxxxxxxxx> 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: https://launchpad.net/~dhis2-users
>>>> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> > Unsubscribe : https://launchpad.net/~dhis2-users
>>>> > More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References