topic Re: Is there any alternative for "InStr() Sql Function" in Qlikview? in QlikView

Is there any alternative for "InStr() Sql Function" in Qlikview?

Fri, 08 Aug 2014 19:07:44 GMT

Hi, I have the following status for my records:

BLOQ. A
BLOQ. B
C BLOQ.
CTEC A
CTEC BLOQ.

Well, I want to filter each record that contains "BLOQ" inside status value. In SQL exists the "InStr()" function but I haven't found any similar function in qlikview.

Re: Is there any alternative for "InStr() Sql Function" in Qlikview?

marcus_sommer — Fri, 08 Aug 2014 19:09:50 GMT

Have a look on match() and wildmatch().

- Marcus

Re: Is there any alternative for "InStr() Sql Function" in Qlikview?

maxgro — Fri, 08 Aug 2014 19:18:30 GMT

where wildmatch(status, '*BLOQ*')

Re: Is there any alternative for "InStr() Sql Function" in Qlikview?

MarcoWedel — Fri, 08 Aug 2014 20:24:20 GMT

To find the position of a substring in a string you can use the Index() function in QlikView.

So this would be the equivalent to the SQL InStr() function.

hope this helps

regards

Marco

Re: Is there any alternative for "InStr() Sql Function" in Qlikview?

Fri, 08 Aug 2014 20:26:56 GMT

Many thanks, thats just that i've been triying to find.