topic Re: Replacement of If statement in App Development

Replacement of If statement

aatish12345 — Thu, 02 Sep 2021 12:53:23 GMT

Hello everyone,

I am using a calculation in dimension with if clause as shown below

=If(A<B, A)

And this dimension I am using in table.,

Here if I am selecting data in A field, automatically data in B field is getting selected and i don't want it . hence I want an alternative to this statement so that I can avoid the selection in field B after selecting data from field A.

Kindly help!

Aatish

Re: Replacement of If statement

stevejoyce — Thu, 02 Sep 2021 12:58:27 GMT

You can try this, and uncheck "Include null values"

=aggr(only({<a={"=a<b"}>} a),a)

Re: Replacement of If statement

aatish12345 — Tue, 07 Sep 2021 17:57:15 GMT

Dear Steve,

Your solution is perfectly working as expected.

Thanks for the help!

Aatish

Re: Replacement of If statement

aatish12345 — Fri, 02 Jun 2023 04:22:43 GMT

Dear Steve, In the solution that you have provided, I want to bypass Region field in order to avoid selection of region field on the table data. for that I have just added region field as shown below

=aggr( {<[Region]=>} only({<a={"=a<b"},[Region]=>} a),a)...but the region field selection is still happening on the data

Can you plz help with any possible solution

Aatish