Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Findoneof() fails with a web file

Have a look into index() function then.

Have a nice evening,

Stefan

6 Replies
MVP
MVP

Findoneof() fails with a web file

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

Re: Findoneof() fails with a web file

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

MVP
MVP

Re: Findoneof() fails with a web file

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

Re: Findoneof() fails with a web file

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

MVP
MVP

Re: Findoneof() fails with a web file

Have a look into index() function then.

Have a nice evening,

Stefan

Not applicable

Re: Findoneof() fails with a web file

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

Community Browser