Compare corresponding values & delete if exists

MK9885 — Sat, 16 Nov 2024 02:37:30 GMT

Hi,

I've a requirement where I have compare 2 values & if either of them is missing do not show in report..

Ex:

1. Patient has a Charge & Adjustment for Key123 for procedure code ABC

2. Same patient has only Charge but no Adjustment for Key123 but different procedure code XYZ.

I wanted to show a chart only which has missing adjustments for corresponding key & code

In above scenario, only point #2 should show up in chart.

My expression is Sum({$<Type= {'Charge', 'Charge Void'} >} Amount_Charge) and

Sum({$<Type= {'Adjustment'} >} Amount_Adjusted) in straight table

Thanks.

topic Compare corresponding values & delete if exists in QlikView