topic Re: How to find common values between 2 strings in UI in QlikView

How to find common values between 2 strings in UI

abe786 — Wed, 15 May 2019 15:06:26 GMT

I have 2 strings which contain multiple numeric values like

String 1: 123, 456, 789

String 2: 234, 567, 456, 231, 123

Is there anyway I can return the common values between 2 strings i.e. 123 and 456 ?

Re: How to find common values between 2 strings in UI

Anil_Babu_Samineni — Thu, 16 May 2019 05:44:01 GMT

If you have four rows like?

String 1: 123, 456, 789

String 2: 234, 567, 456, 231, 123

String 3: 1234, 4567, 789

String 4: 2345, 567, 4567, 231, 123

Re: How to find common values between 2 strings in UI

tresB — Thu, 16 May 2019 06:20:51 GMT

Doing it in UI using qlik function would not be very dynamic. Script solution would the best way to go. Otherwise create your own function as macro and then use; again using macro function has it's limitations.

Re: How to find common values between 2 strings in UI

abe786 — Thu, 16 May 2019 07:21:51 GMT

Actually these string are dynamically generated based on user selections. I need the intersection to be computed and stored in a variable. I was thinking of doing same with an variable starting with = If I go the macro way, probably I would need an action to invoke the macro on each user selection ?

Re: How to find common values between 2 strings in UI

tresB — Thu, 16 May 2019 08:04:35 GMT

Macro function would not need an action. However, using user-defined macro function in the server
and client environment might not be very smooth. Could you please create a sample app and explain the expected output there with business scenario?