Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to search in concatenated fields

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!

Tags (3)
4 Replies
jsn
Honored Contributor

Re: How to search in concatenated fields

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;

Not applicable

Re: How to search in concatenated fields

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'.

Not applicable

Re: How to search in concatenated fields

Hi,

U can use match function wildmatch

like match(FIELDNAME,'*d*')

       wildMatch(FIELDNAME,'*d*')

~kabilan k

Not applicable

Re: How to search in concatenated fields

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.

Community Browser