Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
)
I have to double post because I cannot edit
please look into the below attached qvw.
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