topic Re: A variable and wildcard search in one string in QlikView

A variable and wildcard search in one string

tinkerz1 — Wed, 17 Jun 2015 08:57:07 GMT

Hi,

If I have records in a field and I want to find a string of text like xxxRedyyyOHLzzz

I have done it like this, but I know what to make OHL a variable

Sum({$<[ABC]={"*RED*OHL*"}>}Data)

But the variable is will come up as text, how can I can it to search on string with a fixed character and a variable

Sum({$<[ABC]={"*RED*$(vVariable)*"}>}Data)

Thanks,

Neil.

pokassov — Wed, 17 Jun 2015 08:59:39 GMT

Sum({$<[ABC]={"*RED*$(=vVariable)*"}>}Data)

tinkerz1 — Wed, 17 Jun 2015 09:06:08 GMT

Hi,

Thanks but putting the variable $(=vVariable) inside the * * it ends up being a text string search.

I am having the same issue,

jonathandienst — Wed, 17 Jun 2015 09:10:22 GMT

Thanks but putting the variable $(=vVariable) inside the * * it ends up being a text string search.

Is that not what you want?

tinkerz1 — Wed, 17 Jun 2015 09:25:15 GMT

It means I am searching for a string called $(=vVariable) Not what the variable is named 'OHL'

Thanks