if on same column - qlik sense

[joeybird]

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

[jpenuliar]

'Catering' is already qualified as 'X' based on the IF condition, therefore 'Y' for 'Catering' does not appear

[antoniotiman]

When result will be 'y' ?

If Department='Catering' then Expr='x'.

[joeybird]

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?

[Anonymous]

If there a single quote missing before Catering :

    if(match([Department],'Catering','Homeware'),'x',if([Department]='Catering','y','OTHER'))

[joeybird]

Hi

that was a typo on this forum,

still does not work

please help

[antoniotiman]

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)

[joeybird]

Hi

this code, wont achieve the 'other' selection

menu should show

x, y, other

please help

[antoniotiman]

LOAD * Inline [
Department,Flag1,Flag2
Catering,y,y
Homeware,x,x
Catering,x,x

Dep1,Other,Other

Dep2,Other,Other

];