Program indicator expressions

Support - Assistance technique
1

Hi

Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == ‘LB’ ',1,0)

to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.

Any guidance is appreciated.

Thanks

Jane

2

Hi there Jane!
The problem with the below condition is that we are using single quotes inside a single quoted statement. This is not supported at the moment.

Not really knowing enough about the use case, I venture into suggeting a possible workaround: If you are able to use the condition below as a filter statement instead of an expression, you can change the aggregation type to "Count", and the expression to "V{event_count}".

Markus

···

10. apr. 2018 kl. 08:09 skrev Jane Greig <jane.greig@london.msf.org>:

Hi
Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:
d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == 'LB' ',1,0)
to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.
Any guidance is appreciated.
Thanks
Jane

________________
Jane Greig, PhD
Epidemiologist MSF-OCA
Manson Unit, MSF-UK

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

3

HI Markus

Thanks for your response. I thought that might be the problem. Unfortunately our use case is more complex than my example, so the filter workaround doesn’t help – we want the indicator to return a combined set of conditions. For example, 3 data elements all with the same option set for delivery of up to 3 babies for a pregnancy, to count not the event once, but 0, 1, 2 or 3 live births (option ‘LB’) from the 3 data elements for baby outcome. It sounds like we will have to make numerous program indicators using filters, and then aggregate indicators to combine them. We were trying to avoid that!

Thanks

Jane

···

From: Markus Bekken [mailto:markus@dhis2.org]

Sent: 12 April 2018 19:02

To: Jane Greig jane.greig@london.msf.org

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Program indicator expressions

Hi there Jane!

The problem with the below condition is that we are using single quotes inside a single quoted statement. This is not supported at the moment.

Not really knowing enough about the use case, I venture into suggeting a possible workaround: If you are able to use the condition below as a filter statement instead of an expression, you can change the aggregation type to “Count”, and the expression to “V{event_count}”.

Markus

  1. apr. 2018 kl. 08:09 skrev Jane Greig jane.greig@london.msf.org:

Hi

Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == ‘LB’ ',1,0)

to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.

Any guidance is appreciated.

Thanks

Jane

Jane Greig, PhD

Epidemiologist MSF-OCA

Manson Unit, MSF-UK

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

4

Ok, I understand - was fearing this could be the reason :slight_smile: The codes need to be quoted when they are text-based, so the other short-term workaround I can think of is to use numeric codes.

Markus

···

12. apr. 2018 kl. 11:06 skrev Jane Greig <jane.greig@london.msf.org>:

HI Markus
Thanks for your response. I thought that might be the problem. Unfortunately our use case is more complex than my example, so the filter workaround doesn’t help – we want the indicator to return a combined set of conditions. For example, 3 data elements all with the same option set for delivery of up to 3 babies for a pregnancy, to count not the event once, but 0, 1, 2 or 3 live births (option ‘LB’) from the 3 data elements for baby outcome. It sounds like we will have to make numerous program indicators using filters, and then aggregate indicators to combine them. We were trying to avoid that!
Thanks
Jane

<>
From: Markus Bekken [mailto:markus@dhis2.org]
Sent: 12 April 2018 19:02
To: Jane Greig <jane.greig@london.msf.org>
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Program indicator expressions

Hi there Jane!
The problem with the below condition is that we are using single quotes inside a single quoted statement. This is not supported at the moment.

Not really knowing enough about the use case, I venture into suggeting a possible workaround: If you are able to use the condition below as a filter statement instead of an expression, you can change the aggregation type to "Count", and the expression to "V{event_count}".

Markus

10. apr. 2018 kl. 08:09 skrev Jane Greig <jane.greig@london.msf.org <mailto:jane.greig@london.msf.org>>:

Hi
Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:
d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == 'LB' ',1,0)
to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.
Any guidance is appreciated.
Thanks
Jane

________________
Jane Greig, PhD
Epidemiologist MSF-OCA
Manson Unit, MSF-UK

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

5

So numeric would solve it for us?

That is, if the code for the option we want is numeric = 2 in all 3 data elements, this should work?:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == 2 ',1,0) +

d2:condition('#{qaDVwQUHD0j.FFpJ2FZU7rJ} == 2 ',1,0) +

d2:condition('#{qaDVwQUHD0j.dLKjtfo7GD3} == 2 ',1,0)

···

From: Markus Bekken [mailto:markus@dhis2.org]

Sent: 12 April 2018 19:09

To: Jane Greig jane.greig@london.msf.org

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Program indicator expressions

Ok, I understand - was fearing this could be the reason :slight_smile: The codes need to be quoted when they are text-based, so the other short-term workaround I can think of is to use numeric codes.

Markus

  1. apr. 2018 kl. 11:06 skrev Jane Greig jane.greig@london.msf.org:

HI Markus

Thanks for your response. I thought that might be the problem. Unfortunately our use case is more complex than my example, so the filter workaround doesn’t help – we want the indicator to return a combined set of conditions. For example, 3 data elements all with the same option set for delivery of up to 3 babies for a pregnancy, to count not the event once, but 0, 1, 2 or 3 live births (option ‘LB’) from the 3 data elements for baby outcome. It sounds like we will have to make numerous program indicators using filters, and then aggregate indicators to combine them. We were trying to avoid that!

Thanks

Jane

From: Markus Bekken [mailto:markus@dhis2.org]

Sent: 12 April 2018 19:02

To: Jane Greig jane.greig@london.msf.org

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Program indicator expressions

Hi there Jane!

The problem with the below condition is that we are using single quotes inside a single quoted statement. This is not supported at the moment.

Not really knowing enough about the use case, I venture into suggeting a possible workaround: If you are able to use the condition below as a filter statement instead of an expression, you can change the aggregation type to “Count”, and the expression to “V{event_count}”.

Markus

  1. apr. 2018 kl. 08:09 skrev Jane Greig jane.greig@london.msf.org:

Hi

Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == ‘LB’ ',1,0)

to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.

Any guidance is appreciated.

Thanks

Jane

Jane Greig, PhD

Epidemiologist MSF-OCA

Manson Unit, MSF-UK

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

6

the below expression should work, yes :slight_smile:

···

12. apr. 2018 kl. 11:13 skrev Jane Greig <jane.greig@london.msf.org>:

So numeric would solve it for us?
That is, if the code for the option we want is numeric = 2 in all 3 data elements, this should work?:
d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == 2 ',1,0) +
d2:condition('#{qaDVwQUHD0j.FFpJ2FZU7rJ} == 2 ',1,0) +
d2:condition('#{qaDVwQUHD0j.dLKjtfo7GD3} == 2 ',1,0)

<>
From: Markus Bekken [mailto:markus@dhis2.org]
Sent: 12 April 2018 19:09
To: Jane Greig <jane.greig@london.msf.org>
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Program indicator expressions

Ok, I understand - was fearing this could be the reason :slight_smile: The codes need to be quoted when they are text-based, so the other short-term workaround I can think of is to use numeric codes.

Markus

12. apr. 2018 kl. 11:06 skrev Jane Greig <jane.greig@london.msf.org <mailto:jane.greig@london.msf.org>>:

HI Markus
Thanks for your response. I thought that might be the problem. Unfortunately our use case is more complex than my example, so the filter workaround doesn’t help – we want the indicator to return a combined set of conditions. For example, 3 data elements all with the same option set for delivery of up to 3 babies for a pregnancy, to count not the event once, but 0, 1, 2 or 3 live births (option ‘LB’) from the 3 data elements for baby outcome. It sounds like we will have to make numerous program indicators using filters, and then aggregate indicators to combine them. We were trying to avoid that!
Thanks
Jane

From: Markus Bekken [mailto:markus@dhis2.org <mailto:markus@dhis2.org>]
Sent: 12 April 2018 19:02
To: Jane Greig <jane.greig@london.msf.org <mailto:jane.greig@london.msf.org>>
Cc: dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Program indicator expressions

Hi there Jane!
The problem with the below condition is that we are using single quotes inside a single quoted statement. This is not supported at the moment.

Not really knowing enough about the use case, I venture into suggeting a possible workaround: If you are able to use the condition below as a filter statement instead of an expression, you can change the aggregation type to "Count", and the expression to "V{event_count}".

Markus

10. apr. 2018 kl. 08:09 skrev Jane Greig <jane.greig@london.msf.org <mailto:jane.greig@london.msf.org>>:

Hi
Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:
d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == 'LB' ',1,0)
to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.
Any guidance is appreciated.
Thanks
Jane

________________
Jane Greig, PhD
Epidemiologist MSF-OCA
Manson Unit, MSF-UK

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

7

Hi Markus,
DHIS V2.28, Database:Postgresql

I tried like this too but i saw error in browser console and result display “false”. like below:

image

···

On Thu, Apr 12, 2018 at 5:34 PM, Markus Bekken markus@dhis2.org wrote:

the below expression should work, yes :slight_smile:

  1. apr. 2018 kl. 11:13 skrev Jane Greig jane.greig@london.msf.org:

So numeric would solve it for us?

That is, if the code for the option we want is numeric = 2 in all 3 data elements, this should work?:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == 2 ',1,0) +

d2:condition('#{qaDVwQUHD0j.FFpJ2FZU7rJ} == 2 ',1,0) +

d2:condition('#{qaDVwQUHD0j.dLKjtfo7GD3} == 2 ',1,0)

From: Markus Bekken [mailto:markus@dhis2.org]
Sent: 12 April 2018 19:09
To: Jane Greig jane.greig@london.msf.org
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Program indicator expressions

Ok, I understand - was fearing this could be the reason :slight_smile: The codes need to be quoted when they are text-based, so the other short-term workaround I can think of is to use numeric codes.

Markus

  1. apr. 2018 kl. 11:06 skrev Jane Greig jane.greig@london.msf.org:

HI Markus

Thanks for your response. I thought that might be the problem. Unfortunately our use case is more complex than my example, so the filter workaround doesn’t help – we want the indicator to return a combined set of conditions. For example, 3 data elements all with the same option set for delivery of up to 3 babies for a pregnancy, to count not the event once, but 0, 1, 2 or 3 live births (option ‘LB’) from the 3 data elements for baby outcome. It sounds like we will have to make numerous program indicators using filters, and then aggregate indicators to combine them. We were trying to avoid that!

Thanks

Jane

From: Markus Bekken [mailto:markus@dhis2.org]
Sent: 12 April 2018 19:02
To: Jane Greig jane.greig@london.msf.org
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Program indicator expressions

Hi there Jane!

The problem with the below condition is that we are using single quotes inside a single quoted statement. This is not supported at the moment.

Not really knowing enough about the use case, I venture into suggeting a possible workaround: If you are able to use the condition below as a filter statement instead of an expression, you can change the aggregation type to “Count”, and the expression to “V{event_count}”.

Markus

  1. apr. 2018 kl. 08:09 skrev Jane Greig jane.greig@london.msf.org:

Hi

Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == ‘LB’ ',1,0)

to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.

Any guidance is appreciated.

Thanks

Jane

Jane Greig, PhD
Epidemiologist MSF-OCA

Manson Unit, MSF-UK

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

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

8

Thanks Channara,

please report this as a bug in Jira.

Markus

···

On Thu, Apr 12, 2018 at 5:34 PM, Markus Bekken markus@dhis2.org wrote:

the below expression should work, yes :slight_smile:

  1. apr. 2018 kl. 11:13 skrev Jane Greig jane.greig@london.msf.org:

So numeric would solve it for us?

That is, if the code for the option we want is numeric = 2 in all 3 data elements, this should work?:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == 2 ',1,0) +

d2:condition('#{qaDVwQUHD0j.FFpJ2FZU7rJ} == 2 ',1,0) +

d2:condition('#{qaDVwQUHD0j.dLKjtfo7GD3} == 2 ',1,0)

From: Markus Bekken [mailto:markus@dhis2.org]
Sent: 12 April 2018 19:09
To: Jane Greig jane.greig@london.msf.org
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Program indicator expressions

Ok, I understand - was fearing this could be the reason :slight_smile: The codes need to be quoted when they are text-based, so the other short-term workaround I can think of is to use numeric codes.

Markus

  1. apr. 2018 kl. 11:06 skrev Jane Greig jane.greig@london.msf.org:

HI Markus

Thanks for your response. I thought that might be the problem. Unfortunately our use case is more complex than my example, so the filter workaround doesn’t help – we want the indicator to return a combined set of conditions. For example, 3 data elements all with the same option set for delivery of up to 3 babies for a pregnancy, to count not the event once, but 0, 1, 2 or 3 live births (option ‘LB’) from the 3 data elements for baby outcome. It sounds like we will have to make numerous program indicators using filters, and then aggregate indicators to combine them. We were trying to avoid that!

Thanks

Jane

From: Markus Bekken [mailto:markus@dhis2.org]
Sent: 12 April 2018 19:02
To: Jane Greig jane.greig@london.msf.org
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Program indicator expressions

Hi there Jane!

The problem with the below condition is that we are using single quotes inside a single quoted statement. This is not supported at the moment.

Not really knowing enough about the use case, I venture into suggeting a possible workaround: If you are able to use the condition below as a filter statement instead of an expression, you can change the aggregation type to “Count”, and the expression to “V{event_count}”.

Markus

  1. apr. 2018 kl. 08:09 skrev Jane Greig jane.greig@london.msf.org:

Hi

Can anyone advise on whether program indicator expressions can use data elements with option sets? They do not appear in the list of data elements available, but it does not tell me my expression using the UID of one is invalid. However, it also does not give me a result. Example I am trying to use is:

d2:condition('#{qaDVwQUHD0j.g4bPEQ4a7WM} == ‘LB’ ',1,0)

to return a value of 1 if that condition is true, otherwise 0. Is that possible and I am just writing my expression wrongly? Even with a Boolean data element that does appear in the list of data elements, I could not get a result using == 1, == TRUE, == Yes.

Any guidance is appreciated.

Thanks

Jane

Jane Greig, PhD
Epidemiologist MSF-OCA

Manson Unit, MSF-UK

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

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