topic Re: Search String in QlikView

Search String

Thu, 20 Sep 2012 19:09:59 GMT

Hi All,

I am using the following search string to create a dynamic report:

=SubStringCount(Concat(Fields, '|'), 'UPSShipmentNumber')

However, when I select only 'UPSShipmentNumber', it also returns 'ShipmentNumber'. Is there any way to limit it to only an exact match?

Re: Search String

Anonymous — Thu, 20 Sep 2012 20:06:13 GMT

You have to rename 'ShipmentNumber' to anything that is not a substring of 'UPSShipmentNumber' (or anything else).

Regards,

Michael

Re: Search String

Thu, 20 Sep 2012 20:12:16 GMT

That was my fear. Thanks for the reply, Michael.

Re: Search String

Anonymous — Thu, 20 Sep 2012 20:14:35 GMT

Why "fear"?

Re: Search String

Thu, 20 Sep 2012 20:18:16 GMT

It shouldn't be a problem, I just have a lot that are like that in my actual data.

Re: Search String

MayilVahanan — Thu, 20 Sep 2012 20:19:38 GMT

Try like this,

Hope that helps

Re: Search String

Anonymous — Thu, 20 Sep 2012 20:22:19 GMT

There is always a little bit modified solution. The field values, for example:
A
ABC
BC
XYZ

Here A and BC are substrings of ABC. Here is what you can do. Load table with two fields, the first one is for selection, the second to use in condition. Only the second field must be without substrings.

In your condition, use this:
=SubStringCount(Concat(NewField, '|'), 'Value of New Field')

Regards,
Michael