Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bullish35
Contributor II

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

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!

1 Solution

Accepted Solutions
Not applicable

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

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.

View solution in original post

2 Replies
Not applicable

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

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.

View solution in original post

bullish35
Contributor II

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

Thank you!