topic Re: How to search in concatenated fields in QlikView

How to search in concatenated fields

Wed, 19 Dec 2012 08:51:53 GMT

Dear all,

hope you can help me.

I want to search for values in a concatenated field. Please see example below:

How can I search for all Customer IDs, which have a 'd' within the field value? I need a function like 'contain' in Excel.

Many thanks!

Re: How to search in concatenated fields

Anonymous — Wed, 19 Dec 2012 08:57:29 GMT

If you want to search in a listbox, use *d*.

If you want to use a where clause or something in a load statement you can use where index(FIELDNAME, 'd')>0;

Re: How to search in concatenated fields

Wed, 19 Dec 2012 09:06:46 GMT

Thanks for your quick answer.

I want to search at the QV desktop. If I use the listbox to select *d* I only get those data records where *d* is the only value, but not those, which contain e. g. 'a, b, d'.

Re: How to search in concatenated fields

Wed, 19 Dec 2012 09:10:43 GMT

Hi,

U can use match function wildmatch

like match(FIELDNAME,'*d*')

wildMatch(FIELDNAME,'*d*')

~kabilan k

Re: How to search in concatenated fields

Wed, 19 Dec 2012 11:52:12 GMT

Hm, I want to allow users to search freely within this field. For example they could search for all customers with a and d in the field value, or for b and c.....

I hope you understand what I mean.