Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Findoneof() fails with a web file

Hi All,

I'm trying to filter rows in a web file using findoneof() function and, when the searched character string is more than 1 character it fails.Could you please take a look at the attached example and see what's wrong with the script/data?

Kind regards,

Przemek

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have a look into index() function then.

Have a nice evening,

Stefan

View solution in original post

6 Replies
swuehl
MVP
MVP

I tried with some more characters in the search string and it seems to work for me.

What is the search string you are trying to use?

On which version of QV are you (I am currently on a machine with QV10SR2)?

Not applicable
Author

10SR3. I've changed the searched string to '-miasto'. See the results in the attached file.

swuehl
MVP
MVP

In your attached sample, position 4 is selected.

In either of the possible values in field @1:n

there is one character out of m, i, a, s, t, o, - on position 4. Or are your looking for a different function?

Not applicable
Author

I was sure that findoneof searches full string. If not, then I would need one which does.

swuehl
MVP
MVP

Have a look into index() function then.

Have a nice evening,

Stefan

Not applicable
Author

Ok., got it - index() is what I'm looking for! Thanks, Stephan.