Find a value within all combinations of a dataset

petergassert — Thu, 05 Dec 2024 18:47:10 GMT

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

Re: Find a value within all combinations of a dataset

Kushal_Chawda — Thu, 05 Dec 2024 20:42:06 GMT

@petergassert share sample data with expected output

topic Find a value within all combinations of a dataset in App Development

Find a value within all combinations of a dataset

Re: Find a value within all combinations of a dataset