How to match a value calculated in a table with intervals in an other table
Good morning!
I have a value (sales percentage) calculated in a table AFTER the Load statements. I want to match this value (which of course depends on user selections) with a fixed interval table.
INTERVAL MATCH is no solutions, as this value is calculated in QlikView and cannot be calculated during Load.
IF is not a solutions as the intervals table constantly changes by the users.
Is there a function like interval match available in qv?
