I need some help with a QlikView logic which keeps challenging me so far. We have 2 tables loaded onto QlikView server.
TableA and TableB.
TableA has columns 'AValue1' and 'AValue2'.
TableB has 'BValue1', 'BValue2', 'BValue3' and 'BValue4', 'BValue5'.
The logic goes like that (translated from vb script)
For each line in TableA
i)if(BValue1 <= AValue1 <= BValue3)and(BValue2 <= AValue2 <= BValue4)thenreturn'BValue5'
ii)if the first condition isnot met, run the following:if AValue1 existsin TableB.BValue1,thencheck:if BValue2 <=AValue2<=BValue4,thenreturn'BValue5'iii)if the second condition isnot met, run the following:if AValue2 existsin TableB.BValue2,thencheck:if BValue1 <= AValue1 <= BValue3 then,return'BValue5'.iv)if nothing from the above is complete,thenreturn blank.
Table2 has many blank values in all its different columns *