How to convert a if statement to set analysis expression

[abc_18]

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]

Hi @abc_18 

If you are using in dimension , then try like below

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

or

if its and condition

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