Composition of program indicator with multiple conditions

Hi everyone,

Am trying to create a program indicator with multiple And/Or conditions. In the past I have not had a problem applying either multiple AND or multiple OR conditions to program indicators on their own. Now I am trying to combine And/Or operations in the filter and seem to be having a bit of difficulty. As an example, I am collecting information on different types of confirmed malaria. The program indicator can meet several of these confirmed malaria conditions to be true so I use OR. I also only want to filter out female cases < 5 so use AND; have tried a couple ways as attached. Any advice would be sincerely appreciated. Am using count as my aggregation operation and event count as the expression. While I do get a data value when I check this in pivot tables, the value is very different then what I see when I apply the same filter in event reports.

Thanks!

Nick

Hi Nick!
Generally the grouped and/or filter should work, and we will have to dig deeper to find the cause here. Can you send me your database offline?

Markus

···
  1. feb. 2017 kl. 10.44 skrev Shurajit Dutta shurajitdutta@gmail.com:

Hi everyone,

Am trying to create a program indicator with multiple And/Or conditions. In the past I have not had a problem applying either multiple AND or multiple OR conditions to program indicators on their own. Now I am trying to combine And/Or operations in the filter and seem to be having a bit of difficulty. As an example, I am collecting information on different types of confirmed malaria. The program indicator can meet several of these confirmed malaria conditions to be true so I use OR. I also only want to filter out female cases < 5 so use AND; have tried a couple ways as attached. Any advice would be sincerely appreciated. Am using count as my aggregation operation and event count as the expression. While I do get a data value when I check this in pivot tables, the value is very different then what I see when I apply the same filter in event reports.

<image.png>

<image.png>

Thanks!

Nick


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