Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bullish35
Creator II
Creator 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

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

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
Creator II
Creator II
Author

Thank you!