Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sculptorlv
Contributor II

Contains or Starts with ??

Hello!

Please help with the expression.

I have result columns with Names.

Then I use expression in Pivot Table. And I have to made IF expression. In this IF I should fins all rows, where Name starts with tow letters "Be".

Which function I have to use?

Thank you.

1 Solution

Accepted Solutions
MVP
MVP

Re: Contains or Starts with ??

What about this:

If(WildMatch(FA_Number, 'E*'), 1, 0)

4 Replies
MVP
MVP

Re: Contains or Starts with ??

You can use Set analysis instead of if. Try this:

{<Name = {'Be*'}>}

sculptorlv
Contributor II

Re: Contains or Starts with ??

You mean like this:

IF (FA_Number = 'E*',1,0)

doesn't work

MVP
MVP

Re: Contains or Starts with ??

What about this:

If(WildMatch(FA_Number, 'E*'), 1, 0)

sculptorlv
Contributor II

Re: Contains or Starts with ??

This works!

Thank you!

Community Browser