Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Sense - using match function

Team

What have I done wrong here please...

[handles],
if(match([knockers], 'slimline_urn','Slim'),

    if(match([knockers], 'urn','Standard'),

    if(match([knockers], 'urn_with_spyhole','Standard (V)'),

    if(match([knockers], 'slimline_urn_with_spyhole','Slim (V)'),

    if(match([knockers], 'ingot','Ingot'),

    if(match([knockers], 'horsetail','Horsetail'),

    if(match([knockers], 'no_knocker','None','None')))))))),

[letterplates]

Thanks in advance

Bing

Tags (4)
1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: Sense - using match function

you misplaced the brackets

if(match([knockers], 'slimline_urn'),'Slim',

    if(match([knockers], 'urn'),'Standard',

    if(match([knockers], 'urn_with_spyhole'),'Standard (V)',

    if(match([knockers], 'slimline_urn_with_spyhole'),'Slim (V)',

    if(match([knockers], 'ingot'),'Ingot',

    if(match([knockers], 'horsetail'),'Horsetail',

    if(match([knockers], 'no_knocker','None'),'None')))))))

3 Replies
lironbaram
Honored Contributor II

Re: Sense - using match function

you misplaced the brackets

if(match([knockers], 'slimline_urn'),'Slim',

    if(match([knockers], 'urn'),'Standard',

    if(match([knockers], 'urn_with_spyhole'),'Standard (V)',

    if(match([knockers], 'slimline_urn_with_spyhole'),'Slim (V)',

    if(match([knockers], 'ingot'),'Ingot',

    if(match([knockers], 'horsetail'),'Horsetail',

    if(match([knockers], 'no_knocker','None'),'None')))))))

Not applicable

Re: Sense - using match function

Sussed it myself people

[handles],
if([knockers] = 'slimline_urn','Slim',

    if([knockers] = 'urn','Standard',

    if([knockers] = 'urn_with_spyhole','Standard (V)',

    if([knockers] = 'slimline_urn_with_spyhole','Slim (V)',

    if([knockers] = 'ingot','Ingot',

    if([knockers] = 'horsetail','Horsetail',

    if([knockers] = 'no_knocker','None','None'))))))) as [knockers],

[letterplates],
Not applicable

Re: Sense - using match function

Cheers, just uploaded another way that works too