Solved: Re: filter in expression - Qlik Community - 1361308

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

I need to filter in an expression

I tried something like this but no luck.

=If(Match(FormName like 'Tablet%',FormName)

If(match(FormName like 'Capsule%',FormName))

And like this.

1 Solution

Accepted Solutions

Hi,

Try this way

If(Wildmatch(FormName,'*Tablet*','*Capsule*'),Formname)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

1 Reply

Hi,

Try this way

If(Wildmatch(FormName,'*Tablet*','*Capsule*'),Formname)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!