Lot of issues with indicators dealing blanks

Hello,

I am experiencing lot of problems when dealing with indicators and blanks.

I’ve open three separated tickets in JIRA:
https://jira.dhis2.org/browse/DHIS2-8059
https://jira.dhis2.org/browse/DHIS2-8060
https://jira.dhis2.org/browse/DHIS2-8061

The summary is:

  • Same indicator has different behaviors when showing alone or with others. Alone is showing blank when the value is blank. But when other indicators are included in the same query, the same indicator gives zeros instead of blanks.
  • Indicators including multiplication of values show zeros, even if one of the multiplicand is blank.
  • if sentences in expression do not allow to give a blank output. In 2.32 the expression is considered as malformed. In 2.30 the expression is accepted but a NaN is returned instead of blank. In 2.30 is not possible to do any workaround since the isNull, isNotNull functions are not working at all.

Al that is very frustrating, thank you for helping !
Here some screencaptures, more details in the JIRA tickets.

Data in the system:

Test1: Indicator is the value of TEST1 Male. Blank it’s ok
bug1_test_alone

Test1b: Indicator is the same. But now it’s showing 0 instead of blank!
bug1_test_with_others

Test2: Indicators are the multiplication of Male and Female. The result is ok for TEST1 (2), but not for TEST2 dataElement (o instead of blank!)

Blanks are not expected as output of indicators…
issue3_blank_output_not_possible_in_indicators

3 Likes

Thanks for sharing these issues, Ramon.

@Scott – maybe you have some ideas?

2 Likes