Create filter

[ttal7878]

Hi,

I want to create a filter in the UI.

IF(Category='A' and Age=0,Yes,

IF(Category<>'A' and Age=0,'No')

if the user selects 'Yes', I want to show all of the IDs that at least one of them match that same condition.

in the example attached, if the user selects 'Yes', the result that will be displayed:

Appreciates any help

[tresesco]

Try something like:

=If(Aggr(Max(If(Category='A' and Age=0,1,

     IF(Category<>'A' and Age=0,'2'))),Category)=1,'Yes',

     If(Aggr(Max(If(Category='A' and Age=0,1,

IF(Category<>'A' and Age=0,'2'))),Category)=2,'No')

)

[Miguel_Angel_Baeyens]

I have to double post because I cannot edit

[shivanisali]

please look into the below attached qvw.

[effinty2112]

Hi Tal Tal,

try this expression as a filter

=if(Aggr(sum(Match(Category,'A')*Match(Age,0)),ID)>=1,'Yes','No')

Picking 'Yes'  gives:

ID	Category	Age
1	A	0
1	A	9

Picking 'No' gives:

ID	Category	Age
2	B	0
3	C	0
3	C	7
2	B	8

cheers

Andrew