# Conditional Indicators for Aggregated type Data Elements

Aoa,

I need to ask a question about indicators like i want to sum the value of numerator on the basis of data element like "sum(case when devalue=true then 1 else 0 end) as totaltrue". like how can we calculate the conditional sum for data element whose type is aggregated not tracker. Kindly explain in detail.
Thank You
Regards: Rabbia Naz

Hi Rabbia,
Just use the True Only type of data element. It should work.

Regards,

Jason

···

On Oct 30, 2017 08:09, rabbia@pace-tech.com wrote:

Aoa,

I need to ask a question about indicators like i want to sum the value of numerator on the basis of data element like “sum(case when devalue=true then 1 else 0 end) as totaltrue”. like how can we calculate the conditional sum for data element whose type is aggregated not tracker. Kindly explain in detail.

Thank You

Regards: Rabbia Naz

Hi Jason,
its not working and if we want the same thing to be done on number data type or you can say integer. what i need to do then ?

Regards: Rabbia Naz

···

On 2017-10-30 19:28, Jason Pickering wrote:

Hi Rabbia,
Just use the True Only type of data element. It should work.

Regards,
Jason

On Oct 30, 2017 08:09, <rabbia@pace-tech.com> wrote:

Aoa,

I need to ask a question about indicators like i want to sum the
value of numerator on the basis of data element like "sum(case when
devalue=true then 1 else 0 end) as totaltrue". like how can we
calculate the conditional sum for data element whose type is
aggregated not tracker. Kindly explain in detail.
Thank You
Regards: Rabbia Naz

_______________________________________________

------

Hi Rabbia,
Just use the True Only type of data element. It should work.

Regards,
Jason

Hi Jason,
its not working and if we want the same thing to be done on number data type or you can say integer. what i need to do then ?

Regards: Rabbia Naz

···

On 2017-10-30 19:28, Jason Pickering wrote:

On Oct 30, 2017 08:09, <rabbia@pace-tech.com> wrote:

Aoa,

I need to ask a question about indicators like i want to sum the
value of numerator on the basis of data element like "sum(case when
devalue=true then 1 else 0 end) as totaltrue". like how can we
calculate the conditional sum for data element whose type is
aggregated not tracker. Kindly explain in detail.
Thank You
Regards: Rabbia Naz

_______________________________________________

------

Hi Rabbia,
What is not working? Could you be more specific?

Data elements of type “True only” should aggregate to 1 when marked as true.

Regards,

Jason

···

On Tue, Oct 31, 2017 at 2:05 PM, rabbia@pace-tech.com wrote:

Hi Rabbia,

Just use the True Only type of data element. It should work.

Regards,

Jason

On 2017-10-30 19:28, Jason Pickering wrote:

Hi Jason,

its not working and if we want the same thing to be done on number data type or you can say integer. what i need to do then ?

Regards: Rabbia Naz

On Oct 30, 2017 08:09, rabbia@pace-tech.com wrote:

Aoa,

I need to ask a question about indicators like i want to sum the

value of numerator on the basis of data element like "sum(case when

devalue=true then 1 else 0 end) as totaltrue". like how can we

calculate the conditional sum for data element whose type is

aggregated not tracker. Kindly explain in detail.

Thank You

Regards: Rabbia Naz

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi jason,
I'm asking about data element of type "Number" or "integer" .how can we get the conditional sum for these type ? when the type is aggregated not trackers. Like I've created Data Elements of the type aggregated, created a 'data entry form' of these data elements. also the indicators I've created for this till now are simple indicators but now i want to create some indicator with condition.
Regards: Rabbia Naz

···

On 2017-11-01 15:45, Jason Pickering wrote:

Hi Rabbia,
What is not working? Could you be more specific?

Data elements of type "True only" should aggregate to 1 when marked as
true.

Regards,
Jason

On Tue, Oct 31, 2017 at 2:05 PM, <rabbia@pace-tech.com> wrote:

On 2017-10-30 19:28, Jason Pickering wrote:

Hi Rabbia,
Just use the True Only type of data element. It should work.

Regards,
Jason

Hi Jason,
its not working and if we want the same thing to be done on number
data type or you can say integer. what i need to do then ?

Regards: Rabbia Naz

On Oct 30, 2017 08:09, <rabbia@pace-tech.com> wrote:

Aoa,

I need to ask a question about indicators like i want to sum the
value of numerator on the basis of data element like "sum(case when
devalue=true then 1 else 0 end) as totaltrue". like how can we
calculate the conditional sum for data element whose type is
aggregated not tracker. Kindly explain in detail.
Thank You
Regards: Rabbia Naz

_______________________________________________
More help : https://help.launchpad.net/ListHelp [2] [2]

------

--

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

------

Hi Rabbia,

Would it be similar to what I asked last week: to be able to have logical indicator, like Indicator = sum of DE1 if DE2=yes ?

Best
Lise

···

-----Original Message-----
From: Dhis2-users [mailto:dhis2-users-bounces+groutl=who.int@lists.launchpad.net] On Behalf Of rabbia@pace-tech.com
Sent: 01 November 2017 12:50
To: Jason Pickering
Cc: Dhis2 Users
Subject: Re: [Dhis2-users] Conditional Indicators for Aggregated type Data Elements

Hi jason,
I'm asking about data element of type "Number" or "integer" .how can we get the conditional sum for these type ? when the type is aggregated not trackers. Like I've created Data Elements of the type aggregated, created a 'data entry form' of these data elements. also the indicators I've created for this till now are simple indicators but now i want to create some indicator with condition.
Regards: Rabbia Naz

On 2017-11-01 15:45, Jason Pickering wrote:

Hi Rabbia,
What is not working? Could you be more specific?

Data elements of type "True only" should aggregate to 1 when marked as
true.

Regards,
Jason

On Tue, Oct 31, 2017 at 2:05 PM, <rabbia@pace-tech.com> wrote:

On 2017-10-30 19:28, Jason Pickering wrote:

Hi Rabbia,
Just use the True Only type of data element. It should work.

Regards,
Jason

Hi Jason,
its not working and if we want the same thing to be done on number
data type or you can say integer. what i need to do then ?

Regards: Rabbia Naz

On Oct 30, 2017 08:09, <rabbia@pace-tech.com> wrote:

Aoa,

I need to ask a question about indicators like i want to sum the
value of numerator on the basis of data element like "sum(case when
devalue=true then 1 else 0 end) as totaltrue". like how can we
calculate the conditional sum for data element whose type is
aggregated not tracker. Kindly explain in detail.
Thank You
Regards: Rabbia Naz

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users [1] [1] Post to :
https://launchpad.net/~dhis2-users [1] [1] More help :

------

--

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

------

_______________________________________________

Yes, it sounds like the same thing.

This has come up many times as a feature request I think and sounds similar to this

https://jira.dhis2.org/browse/DHIS2-1677

Its currently not possible, but you can have a look at the work from HISP Tanzania which may make this possible at least in the front-end

https://play.dhis2.org/appstore/app/dXX2Fk6jwCX

Regards,

Jason

···

On Wed, Nov 1, 2017 at 1:16 PM, GROUT, Lise groutl@who.int wrote:

Hi Rabbia,

Would it be similar to what I asked last week: to be able to have logical indicator, like Indicator = sum of DE1 if DE2=yes ?

Best

Lise

-----Original Message-----

From: Dhis2-users [mailto:dhis2-users-bounces+groutl=who.int@lists.launchpad.net] On Behalf Of rabbia@pace-tech.com

Sent: 01 November 2017 12:50

To: Jason Pickering

Cc: Dhis2 Users

Subject: Re: [Dhis2-users] Conditional Indicators for Aggregated type Data Elements

Hi jason,

I’m asking about data element of type “Number” or “integer” .how can we get the conditional sum for these type ? when the type is aggregated not trackers. Like I’ve created Data Elements of the type aggregated, created a ‘data entry form’ of these data elements. also the indicators I’ve created for this till now are simple indicators but now i want to create some indicator with condition.

Regards: Rabbia Naz

On 2017-11-01 15:45, Jason Pickering wrote:

Hi Rabbia,

What is not working? Could you be more specific?

Data elements of type “True only” should aggregate to 1 when marked as

true.

Regards,

Jason

On Tue, Oct 31, 2017 at 2:05 PM, rabbia@pace-tech.com wrote:

On 2017-10-30 19:28, Jason Pickering wrote:

Hi Rabbia,

Just use the True Only type of data element. It should work.

Regards,

Jason

Hi Jason,

its not working and if we want the same thing to be done on number

data type or you can say integer. what i need to do then ?

Regards: Rabbia Naz

On Oct 30, 2017 08:09, rabbia@pace-tech.com wrote:

Aoa,

I need to ask a question about indicators like i want to sum the

value of numerator on the basis of data element like "sum(case when

devalue=true then 1 else 0 end) as totaltrue". like how can we

calculate the conditional sum for data element whose type is

aggregated not tracker. Kindly explain in detail.

Thank You

Regards: Rabbia Naz

Mailing list: https://launchpad.net/~dhis2-users [1] [1] Post to :

https://launchpad.net/~dhis2-users [1] [1] More help :

Jason P. Pickering

tel:+46764147049