← Back to team overview

dhis2-devs team mailing list archive

  1. dhis2-devs team
  2. Mailing list archive
  3. Message #48269

Re: [Dhis2-users] Program Indicators

  Thread Previous • Date Previous • • Thread Next 
Hello Marcus,

Thank you very much, I have the options in the right format as you have said, now the problem is,

do I use quotation marks for the numerical codes i.e.


#{yUVXpYVeY6I.Z8W89lDV4IL} ==‘1'


(Demographics, Admission and Treatment.Gender ==‘1')



or just


#{yUVXpYVeY6I.Z8W89lDV4IL} ==1


(Demographics, Admission and Treatment.Gender ==‘1')



both of them do not bring any results

Regards.

Seth Okeyo| Data Management Officer
Drugs for Neglected Diseases initiative – Africa Regional Office
Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 00505| Nairobi | Kenya
T: +254 020 3995000 | M: +254 727 389 149| sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx> | skype: dndi_seth.okeyo
Best Science for the Most Neglected | www.dndi.org<http://www.dndi.org/>

________________________________
From: Markus Bekken <markus.bekken@xxxxxxxxx>
Sent: Friday, January 13, 2017 11:24:06 AM
To: Seth Okeyo
Cc: Busoye Anifalaje; dhis2-users; Dhis2-devs; Groupe Francophone du DHIS 2; DHIS 2 developers
Subject: Re: [Dhis2-users] Program Indicators

Hi there Seth,
the option set codes only need to be unique within each option set.

One option set can be
Male - 1
Female - 2

And another can be
Yes - 1
No - 0

But when your option set is
Male - 1
Female - 1
...then the two options will always be seen as "1" when analyzing the data.

Markus

13. jan. 2017 kl. 07.54 skrev Seth Okeyo <sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx>>:

Hello Busoye,
Yes, in event reports, it works fine, but my intention is to make Program indicators which someone else can work with. does it mean every option set has to have a unique code across all the other option sets?
Regards

Seth Okeyo| Data Management Officer
Drugs for Neglected Diseases initiative – Africa Regional Office
Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 00505| Nairobi | Kenya
T: +254 020 3995000 | M: +254 727 389 149| sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx> | skype: dndi_seth.okeyo
Best Science for the Most Neglected | www.dndi.org<http://www.dndi.org/>

________________________________
From: Busoye Anifalaje <busoye@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx>>
Sent: Thursday, January 12, 2017 5:05:43 PM
To: Seth Okeyo
Cc: dhis2-users; Dhis2-devs; DHIS 2 developers; Groupe Francophone du DHIS 2; GROUT, Lise
Subject: Re: [Dhis2-users] Program Indicators

For a single option set, the options should have unique codes otherwise there would be no way to identify and analyse these through program indicators. For instance if your code for Male and Female are both 1, then this isn’t going to work.

>From your example, let’s say your code for Male is 1. Assuming the Value Type for the option text is Text, the filter should be something like this


filter:
#{yUVXpYVeY6I.Z8W89lDV4IL} ==‘1'

(Demographics, Admission and Treatment.Gender ==‘1')

If you do not have unique codes, you can still get the results in Event reports. In this case, choose your Program and Program stage. Select the data element and then use the filter next to the data element name to choose “Male” or “Female” (see attached example).

Cheers


- -


Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 busoye@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx> | http://www.baosystems.com<http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

<Event Report Option Sets.png>


On 12 Jan 2017, at 13:54, Seth Okeyo <sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx>> wrote:

Hi Busoye,
In the codes, I used numbers,1,2,3,......x, which makes them the same across different option sets.
but this, does not work too.
regards

Seth Okeyo| Data Management Officer
Drugs for Neglected Diseases initiative – Africa Regional Office
Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 00505| Nairobi | Kenya
T: +254 020 3995000 | M: +254 727 389 149| sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx> | skype: dndi_seth.okeyo
Best Science for the Most Neglected | www.dndi.org<http://www.dndi.org/>

________________________________
From: Busoye Anifalaje <busoye@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx>>
Sent: Thursday, January 12, 2017 3:53:25 PM
To: Seth Okeyo
Cc: dhis2-users; Dhis2-devs; DHIS 2 developers; Groupe Francophone du DHIS 2; GROUT, Lise
Subject: Re: [Dhis2-users] Program Indicators

Hi Seth,

You should try using the code instead of the label name. Version 2.22 also has a code.



- -


Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 busoye@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx> | http://www.baosystems.com<http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

On 12 Jan 2017, at 12:28, Seth Okeyo <sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx>> wrote:

Hi Busoye
I'm using the label name for option set... we are running version 2.22.
Regards

Seth Okeyo| Data Management Officer
Drugs for Neglected Diseases initiative – Africa Regional Office
Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 00505| Nairobi | Kenya
T: +254 020 3995000 | M: +254 727 389 149| sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx> | skype: dndi_seth.okeyo
Best Science for the Most Neglected | www.dndi.org<http://www.dndi.org/>

________________________________
From: Busoye Anifalaje <busoye@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx>>
Sent: Thursday, January 12, 2017 2:56:53 PM
To: Seth Okeyo
Cc: dhis2-users; Dhis2-devs; DHIS 2 developers; Groupe Francophone du DHIS 2; GROUT, Lise
Subject: Re: [Dhis2-users] Program Indicators

Hi Seth,

Are you are using the code for the option set value instead of the label name?

Cheers,

- -


Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 busoye@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx> | http://www.baosystems.com<http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

On 12 Jan 2017, at 11:52, Seth Okeyo <sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx>> wrote:

Hello,
I'm developing Program indicators using data elements with Option sets, for example "Gender" with options "Male and Female", when I follow the manual by putting it like this:

expression:(event_count)

filter:
#{yUVXpYVeY6I.Z8W89lDV4IL} =='Male'

(Demographics, Admission and Treatment.Gender =='Male')

the data visualization returns empty results, is there something I'm not doing right?

regards.

Seth Okeyo| Data Management Officer
Drugs for Neglected Diseases initiative – Africa Regional Office
Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 00505| Nairobi | Kenya
T: +254 020 3995000 | M: +254 727 389 149| sokeyo@xxxxxxxx<mailto:sokeyo@xxxxxxxx> | skype: dndi_seth.okeyo
Best Science for the Most Neglected | www.dndi.org<http://www.dndi.org/>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

<PastedGraphic-1.tiff>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Follow ups

References

  Thread Previous • Date Previous • • Thread Next