topic if on same column - qlik sense in App Development

if on same column - qlik sense

joeybird — Thu, 23 Nov 2017 15:25:25 GMT

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

Re: if on same column - qlik sense

jpenuliar — Thu, 23 Nov 2017 15:32:43 GMT

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

Re: if on same column - qlik sense

antoniotiman — Thu, 23 Nov 2017 15:33:00 GMT

When result will be 'y' ?

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

Re: if on same column - qlik sense

joeybird — Fri, 24 Nov 2017 09:24:52 GMT

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?

Re: if on same column - qlik sense

Anonymous — Fri, 24 Nov 2017 09:31:16 GMT

If there a single quote missing before Catering :

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

Re: if on same column - qlik sense

joeybird — Fri, 24 Nov 2017 09:34:26 GMT

that was a typo on this forum,

still does not work

please help

Re: if on same column - qlik sense

antoniotiman — Fri, 24 Nov 2017 09:47:47 GMT

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)

Re: if on same column - qlik sense

joeybird — Fri, 24 Nov 2017 09:56:19 GMT

this code, wont achieve the 'other' selection

menu should show

x, y, other

please help

Re: if on same column - qlik sense

antoniotiman — Fri, 24 Nov 2017 10:08:07 GMT

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

Dep1,Other,Other

Dep2,Other,Other

];