Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
MK9885
Master II
Master II

Compare corresponding values & delete if exists

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.

Labels (1)
0 Replies