Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
Thank you!