topic Re: Doubt with searching values in QlikView

Doubt with searching values

Thu, 01 Aug 2013 18:39:26 GMT

Dears,

I have a field, colled Description, and I would like to search for everything that contains L1 and do not contain L2.... how can I do it?

There is no simple behaviour, once it is a text descriptions!

I've tryied something like "=L1" "<>L2" But it didn´t worked!

Thanks per your attention,

Best regards

Re: Doubt with searching values

MayilVahanan — Thu, 01 Aug 2013 18:52:14 GMT

Description contains??

For search, simply gives *L1*

can you explain it in more details?

Re: Doubt with searching values

Miguel_Angel_Baeyens — Thu, 01 Aug 2013 18:58:13 GMT

Hi,

If you mean in the same string one char but not another one, try this:

='(' & Concat({< Name = {"J*"} - {"*l"} >} Name, '|') & ')'

In this case, will select all names that start with J and not end with lowercase L. Chech the app attached.

Hope that helps.

Miguel

Re: Doubt with searching values

Thu, 01 Aug 2013 18:59:50 GMT

Dears,

I would like to search for results values that contains "L1" written anywehere of the line, and do not contain the word "L2" written.

Thanks per your assistance,

Best regards

Re: Doubt with searching values

Thu, 01 Aug 2013 19:03:53 GMT

Where should I put it?

Re: Doubt with searching values

Miguel_Angel_Baeyens — Thu, 01 Aug 2013 19:09:02 GMT

As in the app attached,

Create a new button, go to the Actions tab in the button properties, add a new action, type Selection, Select in Field, set the field name and the expression above as the search string.

Hope that helps.

Miguel

Re: Doubt with searching values

Thu, 01 Aug 2013 19:32:50 GMT

Thanks a lot per your attention,

But it didn´t worked!

Imagine I have the following data

L1 Inspection

L1 Ins

L1 Main

L1, L2, L3

L1, L2 Inspections

L2, L1 Inspection
L2 Inspection

L2, L1 Insp

...

I would like to have something showing me, as result of my search, the following values:

L1 Inspection

L1 Ins

L1 Main

How can I do it?

Best regards,

Re: Doubt with searching values

Miguel_Angel_Baeyens — Thu, 01 Aug 2013 19:44:22 GMT

Hi,

Yes, it does work. Check attached.

Regards.

Miguel