Find a value within all combinations of a dataset

[petergassert]

Hi,

is there an easy or slim way to check values within a skript.

I got a value x in a field within a cluster, that could be within an other field one value or the sum of all combinationations.

Example:

Example 1
Cluster	X	Y	Value to look for
A	10	10	=> Direct Match
Example 2
B	10	4	Indirect Match because 4+6 =10
B	10	6	Indirect Match because 4+6 =10
Example 3
C	10	5	Indirect Match because 5+5 =10
C	10	6	No Match with none of the values because 6+5=11
C	10	5	Indirect Match because 5+5 =10

The maximum of Values within a cluster is 5.
This means that:

• 1 value cound be correct,
• the sum of 2 could be correct
• the sum of 3 could be correct
• the sum of 4 could be correct
• the sum of 5 could be correct

Is there a function or does anyone have an idea how to solve such a proove within the qlik script?

As output i just need the feedback which rows fit for a match.

Thanks in advance,
Peter

[Kushal_Chawda]

@petergassert  share sample data with expected output