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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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