Compare value of two tables, generate a third table, populate table based on condition?

[bullish35]

Hello,

I am loading the following tables from two different sources:

TABLE A = Incurred amount

TABLE B = Paid amount

I would like to create a third table that will be populated by either the amount in A or the amount in B, based on the following condition:

TABLE C = if B>0, use the value in B, otherwise use the value in A

Can someone help me script this? I have uploaded screenshots of the load scripts for A and B.

Thanks in advance!

[#2 · Accepted solution]

Create a table with Claim Number as the dimension. Then add the expression:

if([Paid Amount] > 0, [Paid Amount], [Incurred Amount])

Since both tables have a Claim Number field, QlikView will automatically join them.

[bullish35]

Thank you!