How to Filter field_1 using condition : where field_2 >= 20 or field_3>=30 ?

[yanivvl0]

hi ,

i need to see population of field_1 where field_2 >= 20 or field_3>=30 ?

it dupose to be the population of all model ,

can anyone help me ?    by Button or any other way ..

thanks!

[Kushal_Chawda]

You can create one button on which you can set the action to select all the field_1 values

Button->Action->Add->Select in field

Field -> field_1

Search string->

='( '& Concat( distinct if(field_2 >= 20 or field_3>=30,chr(34) & field_1 & chr(34)),'|') & ')'

[sunny_talwar · Accepted solution]

Also, you can use set analysis

='( '& Concat( DISTINCT {<field_2 = {'>= 20'}>+<{field_3 = {'>=30'}>} Chr(34) & field_1 & Chr(34), '|') & ')'

[yanivvl0]

hi Kushal and Sunny , i tried to implement your formula but no good ,

am i missing something ?

i add example , hope to find solution ...  THANKS !

[yanivvl0]

hi Kushal  , i tried to implement your formula but no good ,

am i missing something ?

i add example , hope to find solution ...  THANKS !

[yanivvl0]

hi   Sunny , i tried to implement your formula but no good ,

am i missing something ?

i add example , hope to find solution ...  THANKS !

[Anil_Babu_Samineni]

Seems, You made mistake over here. Remove = and then try

[yanivvl0]

THANKS!

[yanivvl0]

HI SUNNY  -   THANKS AGAIN  !