# 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]

Bing

Tags (4)
1 Solution

Accepted Solutions
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
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