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
