Dynamically evaluate set of rules to derive calculated field (in load script)
I need to evaluate a set of data criteria to assign buckets to each transaction record. Each row could potentially meet criteria for multiple buckets. I cannot hardcode these rules with if-then-else as they will change frequently with rules being added and removed.
The result needs to be persisted into a predefined set of buckets, A1, A2, A3 and None.
I was wondering if a dynamic if-then-else could be constructed from the content before evaluating each transaction or if there is a more elegant option in Qlik to achieve this.
Any assistance is appreciated! Thanks
An example of a set of rules is below in the table.
Criteria + Value
Transaction data may look like below. Some rows meet multiple Bucket criteria (ex: Row 5).
Some rows may not meet any criteria and they need to be marked 'None'.