topic Re: How to match text to field content in script? in QlikView

How to match text to field content in script?

hugmarcel — Fri, 06 Jun 2014 14:31:34 GMT

I have a script statement

.. match('dx',table_field1) where table_field1 contains string 'da;dx;dz'.

Result should be 2 as dx is second element in string compared to 'dx'.

How do I have to transform table_field1 so that I am getting correct result 2?

I tried something like .

match('dx',chr(39) & replace(table_field1,';',chr(39) & ',' & chr(39)) & chr(39))

but this does not work.

Thx - Marcel

jonathandienst — Fri, 06 Jun 2014 14:53:04 GMT

This works:

=match('dx', $(=chr(39) & Replace(table_field1, ';', chr(39) & ',' & chr(39)) & chr(39)))

(as long as there is only one possible value of table_field1 (at the calculation point))

HTH

Jonathan

hugmarcel — Fri, 06 Jun 2014 14:57:27 GMT

Hi Jonathan

i tried this to. It works in a diagram, but not in Script!

In Script, I am getting error

Error in expression:

Match takes at least 2 parameters

Thx - Marcel

hugmarcel — Fri, 06 Jun 2014 15:26:21 GMT

I guess I found a solution, I switch the match parameters, use substringcount and index instead:

SUBSTRINGCOUNT(MID(table_field1,1,INDEX(';'&table_field1&';' , ';'&'dx'&';')), ';') + 1

Marcel