topic Re: How to convert a if statement to set analysis expression in App Development

How to convert a if statement to set analysis expression

abc_18 — Mon, 20 Dec 2021 21:08:46 GMT

I have a if statement as below:-

if(longitude < 68.7 or latitude > 97.25,longitude), now I have to show data only where flag={'Y'} in front end expression.

How to convert this, if statement to set analysis which include flag value as well?

I tried using only function, but didn't get the required output.

Regards

MayilVahanan — Wed, 02 Dec 2020 09:32:37 GMT

If you are using in dimension , then try like below

Aggr(Only({<longitude ={"< 68.7"}, Flag ={1}>+ <latitude ={"> 97.25"}, Flag={1}>}longitude ), longitude )

if its and condition

Aggr(Only({<longitude ={"< 68.7"}, Flag ={1},latitude ={"> 97.25"}>}longitude ), longitude )