Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sculptorlv
Creator III
Creator III

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
sunny_talwar

What about this:

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

View solution in original post

4 Replies
sunny_talwar

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

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

sculptorlv
Creator III
Creator III
Author

You mean like this:

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

doesn't work

sunny_talwar

What about this:

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

sculptorlv
Creator III
Creator III
Author

This works!

Thank you!