topic Re: Comparing two aggr in an if in App Development

Comparing two aggr in an if

Obsyky — Wed, 11 Oct 2023 06:42:58 GMT

Hello,

I want to compare two aggrs in an if, but the comparison doesn't return the result I want...

aggr1 :
aggr(Only({$<DATE_START={"<=$(=vDATE1)"},DATE_END={">$(=vDATE1)"},STATE_ID -= {'Out'}>}ATTRIBUTE),ID)
The result is -> 'XX'

aggr2 :
aggr(Only({$<DATE_START={"<=$(=vDATE2)"},DATE_END={">$(=vDATE2)"},STATE_ID -= {'Out'}>}ATTRIBUTE),ID)
The result is -> 'XX'

If :
If(aggr(Only({$<DATE_START={"<=$(=vDATE1)"},DATE_END={">$(=vDATE1)"},STATE_ID -= {'Out'}>}ATTRIBUTE),ID) = aggr(Only({$<DATE_START={"<=$(=vDATE2)"},DATE_END={">$(=vDATE2)"},STATE_ID -= {'Out'}>}ATTRIBUTE),ID),Null(),ID)
The result is -> ID
Except that as the two aggr are identical, I'll end up with a Null.

Why doesn't the comparison work?

Thank you very much.

Re: Comparing two aggr in an if

Mark_Little — Wed, 11 Oct 2023 06:59:55 GMT

Hi,

Have broken the Set analysis down?

I.e. Created a table with Above and comparing? Ensuring that the Aggr is always bring through a single value for the only function on both sides?

Re: Comparing two aggr in an if

Obsyky — Wed, 11 Oct 2023 07:03:20 GMT

The value is unique for each id

Just that it can change according to the date, and the goal is to display only the IDs that may have changed between two dates

Re: Comparing two aggr in an if

marcus_sommer — Wed, 11 Oct 2023 15:06:29 GMT

You may try it in this way:

If(aggr(
Only({$<DATE_START={"<=$(=vDATE1)"},DATE_END={">$(=vDATE1)"},STATE_ID -= {'Out'}>}ATTRIBUTE) <>
Only({$<DATE_START={"<=$(=vDATE2)"},DATE_END={">$(=vDATE2)"},STATE_ID -= {'Out'}>}ATTRIBUTE),
ID),ID)

Re: Comparing two aggr in an if

Obsyky — Thu, 12 Oct 2023 06:45:27 GMT

It always returns a value 😕

Re: Comparing two aggr in an if

marcus_sommer — Thu, 12 Oct 2023 07:39:42 GMT

What happens if you put ID as dimension in a table-chart and both only() calculations without the aggr() as single expressions and a third one comparing them?

Re: Comparing two aggr in an if

vincent_ardiet_ — Thu, 12 Oct 2023 08:57:33 GMT

What is the dimension you are using in your chart?

Re: Comparing two aggr in an if

Obsyky — Thu, 12 Oct 2023 11:54:33 GMT

I've found a solution to my problem. I simply replaced the "=" between the aggr() with a "like".

Thank you very much for your help!