Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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')))))))

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

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
Author

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
Author

Cheers, just uploaded another way that works too