← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Aggregation query builder

 

Hi Channara,

While it might not have an explicit 'IF', with the help of: 'AND', 'OR',
'==NULL', '!=NULL' and other logical operators, most if not all scenarios
of the IF - Condition can be evaluated especially since the goal is to
aggregate a value only if a specific condition holds.

i.e if( *Registration !=NULL*) THEN ... Aggregate

The same condition in RED is what would go in the condition text area. If
it is a nested IF(one inside the other) , then combining the different
conditions with AND will yield the same effect.


regards,

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 788 993565 | +256 757 662752
kasozis@xxxxxxxxx | skasozi@xxxxxxxxxxx <kasozis@xxxxxxxxx> | Skype:
sam.kasoziug

On Mon, Mar 2, 2015 at 2:02 PM, Chau Thu Tran <cthutran@xxxxxxxxx> wrote:

> Hi Channara,
>
>  Aggregation query builder doesn't have if-condition
>
> Tran Chau
> On Mar 2, 2015 4:30 PM, "channara rin" <rin.channara@xxxxxxxxx> wrote:
>
>> Hi DHIS2 family,
>> Do you know Aggregation query builder has if-condition?
>>
>> Thanks
>> CHANNARA
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References