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: 
Not applicable

Showing non-matching entries in a table

Hi guys,

I'm rather new to Qlik. So far I've managed to get my data in properly and build some charts, however I'm a little stuck. I currently have two relevant tables; RSEG (Invoices) and MSEG (Material movements). The applicable synthetic key is a combination of Order-number and Order-row (EBELN/EBELP).

Now my goal is to show in a table/chart the orders (EBELN/EBELP) which have been billed (thus occur in RSEG) but have not been received (thus do not occur in MSEG). How can I make such an expression?

Thank you!

0 Replies