How to subtract string from a string, subfield-wise

[swuehl]

Hello all,

I've got two strings:

Let A = 'A, B, C, D, E';

Let B = 'C, E';

I want to get the difference / missing substrings when comparing B with A, i.e. result = 'A, B, D'

B is always is subgroup of A, delimiter is ', ' in this example but could be set as wanted.

In real application, I build the strings dynamically in the frontend, the solution also needs to be one single expression (all expressions are within a chart object with dimensions and need to regard the dimensions, but first start with a simple example).

So, anyone has a nice solution to this already?

Thanks in advance,

Stefan

[swuehl]

Jason,

I agree that doing such stuff in the script might be better - if the strings and substrings are preknown, in my settings they were not, as you already noticed.

I am a little fan of the valueloop() function, since it allows to create a loop in an aggregating expression, e.g. to rebuild the mathematical summing operation using an index (summation symbol ∑ ).

I believe that is not the way the developers at QT were thinking of, but nevermind.

Thanks for sharing your solution,

Stefan

[#3]

It helped me with another situation. Thanks for posting your solution.

[swuehl]

You're welcome.

Just out of curiosity, could you outline in which context the above solution helped you?

[vikasmahajan]

Hi Stefan,

Can you please attach Qlik Sense QVF example I need same logic to be implemented !

Thanks

Vikas