topic MATCH multiple values in QlikView

MATCH multiple values

dafnis14 — Sat, 16 Nov 2024 21:01:03 GMT

Hi,

Is there a way to match a string to more then one string (AND condition)?

For example:

I have a field with multiple flight classes. For example:

"Low Economy, High Business, First Class".

If the field has the values "Economy" and "Business", it would be linked to a description field: "Combined Economy/Business".

How can I apply such a matching condition?

Thanks!

Re: MATCH multiple values

asinha1991 — Fri, 19 Apr 2019 20:05:26 GMT

if sequence of classes in the string remains same, you can use something like this
=if(WildMatch('Low Economy, High Business, First Class','*Economy*Business*'),'Combined Business/Economy',0)

if not , you can split the value using subfield and then re concatenate in a specified order using concat( can help here if you want), then apply wildmatch.

Re: MATCH multiple values

dafnis14 — Sat, 20 Apr 2019 04:28:36 GMT

Hi Asinha,

Thanks for your reply!

The problem is that the sequence is not the same.

Besides, we are talking about fields with different strings: both source and target. So the script has to be generic..

My current solution is to prepare beforehand he possible combinations of strings for the the wild match..

But I hope there is a better one 🙂