# Category suggestions?

I have an Excel table as below. As you can see, there are thre dimensions: Age, Sex and CDV/PTME. However, if I combine all of these, I get 8 fields instead of the 5 I need (because PTME is not broken down by age and sex). I can of course grey out three fields, but it does not make sense to have a field such as PTME F > 14 yrs as the 5th field. Is there a good way to acheive this with categorycombos?

I suppose the alternative is to keep PTME separate and rather create an indicator that sums it with the other 4. Other suggestions?

Number of persons

CDV :F ≤14yr

CDV :M ≤14yr

CDV TOTAL ≤14yr

CDV :F >14 yr

CDV :M >14yr

CDV TOTAL > 14 yr

** PTME**

TOTAL

Hi,

(given that thunderbird renders your example correctly), I would say that "Number of persons" is not really a data element at all. It contains no info, so I would drop it, and rather have two DEs:

CDV, and
PTME

CDV would then have the age and gender categegory combo. The grand total of CDV and PTME can be made with an indicator.

Johan

···

On 18.07.2013 13:16, Knut Staring wrote:

I have an Excel table as below. As you can see, there are thre
dimensions: Age, Sex and CDV/PTME. However, if I combine all of these, I
get 8 fields instead of the 5 I need (because PTME is not broken down by
age and sex). I can of course grey out three fields, but it does not
make sense to have a field such as PTME F > 14 yrs as the 5th field. Is
there a good way to acheive this with categorycombos?

I suppose the alternative is to keep PTME separate and rather create an
indicator that sums it with the other 4. Other suggestions?

*Number of persons*

*CDV :F ≤14yr*

*CDV :M ≤14yr*

*CDV TOTAL ≤14yr*

*CDV :F >14 yr*

*CDV :M >14yr*

*CDV TOTAL > 14 yr*

* PTME*

*TOTAL*

_______________________________________________

Actually, I had not fully translated the data element, it’s rather something like
“Number of people counseled and tested for HIV and have received the result”. This is common for all the breakdowns - but it could of course be that we should have

Number of people counseled and tested for HIV and have received the result - CDV

and

Number of people counseled and tested for HIV and have received the result - PTME

as two dataelements.

···

On Thu, Jul 18, 2013 at 1:28 PM, Johan Sæbø johansa@ifi.uio.no wrote:

Hi,

(given that thunderbird renders your example correctly), I would say that “Number of persons” is not really a data element at all. It contains no info, so I would drop it, and rather have two DEs:

CDV, and

PTME

CDV would then have the age and gender categegory combo. The grand total of CDV and PTME can be made with an indicator.

Johan

On 18.07.2013 13:16, Knut Staring wrote:

I have an Excel table as below. As you can see, there are thre

dimensions: Age, Sex and CDV/PTME. However, if I combine all of these, I

get 8 fields instead of the 5 I need (because PTME is not broken down by

age and sex). I can of course grey out three fields, but it does not

make sense to have a field such as PTME F > 14 yrs as the 5th field. Is

there a good way to acheive this with categorycombos?

I suppose the alternative is to keep PTME separate and rather create an

indicator that sums it with the other 4. Other suggestions?

Number of persons

CDV :F ≤14yr

CDV :M ≤14yr

CDV TOTAL ≤14yr

CDV :F >14 yr

CDV :M >14yr

CDV TOTAL > 14 yr

• PTME*

TOTAL

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

Yes, I suspected that. The right breakdown for groups, DEs, categories etc is always tricky. I would say there is no "right" way to do it. It all depends on your needs for maintenance and getting totals and subtotals, though DHIS is now so flexible that you can do it most ways without much hassle.

I would probably have made a group for these two DEs ("HIV counseling and testing" or something), and an indicator for the grand total.

···

On 18.07.2013 13:34, Knut Staring wrote:

Actually, I had not fully translated the data element, it's rather
something like
"Number of people counseled and tested for HIV and have received the
result". This is common for all the breakdowns - but it could of course
be that we should have

Number of people counseled and tested for HIV and have received the
result - CDV

and

Number of people counseled and tested for HIV and have received the
result - PTME

as two dataelements.

On Thu, Jul 18, 2013 at 1:28 PM, Johan Sæbø <johansa@ifi.uio.no > <mailto:johansa@ifi.uio.no>> wrote:

Hi,

(given that thunderbird renders your example correctly), I would say
that "Number of persons" is not really a data element at all. It
contains no info, so I would drop it, and rather have two DEs:

CDV, and
PTME

CDV would then have the age and gender categegory combo. The grand
total of CDV and PTME can be made with an indicator.

Johan

On 18.07.2013 13:16, Knut Staring wrote:

I have an Excel table as below. As you can see, there are thre
dimensions: Age, Sex and CDV/PTME. However, if I combine all of
these, I
get 8 fields instead of the 5 I need (because PTME is not broken
down by
age and sex). I can of course grey out three fields, but it does not
make sense to have a field such as PTME F > 14 yrs as the 5th
field. Is
there a good way to acheive this with categorycombos?

I suppose the alternative is to keep PTME separate and rather
create an
indicator that sums it with the other 4. Other suggestions?

*Number of persons*

*CDV :F ≤14yr*

*CDV :M ≤14yr*

*CDV TOTAL ≤14yr*

*CDV :F >14 yr*

*CDV :M >14yr*

*CDV TOTAL > 14 yr*

* PTME*

*TOTAL*

_________________________________________________

_________________________________________________