Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I have this in a filter pane
trying to do an if on same column, with no joy
if(match([Department],'Catering','Homeware'),'x',if([Department]=Catering','y','OTHER'))
I cant seem to get y to appear
any help team please
'Catering' is already qualified as 'X' based on the IF condition, therefore 'Y' for 'Catering' does not appear
When result will be 'y' ?
If Department='Catering' then Expr='x'.
Hi
I just wanted if someone selected x, they would get both those departments
Catering and Homeware
and if they select Y they would get just catering
the rest other, as trying to make a simple quick select filter pane...
is there another method you can suggest please?
If there a single quote missing before Catering :
if(match([Department],'Catering','Homeware'),'x',if([Department]='Catering','y','OTHER'))
Hi
that was a typo on this forum,
still does not work
please help
May be this :
In Script
LOAD * Inline [
Department,Flag1,Flag2
Catering,y,y
Homeware,x,x
Catering,x,x
];
Expression Filter
=Aggr(Only({<Flag1=P(Flag2),Flag1>} Flag1),Flag1)
Hi
this code, wont achieve the 'other' selection
menu should show
x, y, other
please help
LOAD * Inline [
Department,Flag1,Flag2
Catering,y,y
Homeware,x,x
Catering,x,x
Dep1,Other,Other
Dep2,Other,Other
];