Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcoARaymundo
Creator III
Creator III

How to identify missing information

Hi averyone!

Please look de attached file

Can anyone help me?

3 Replies
Anonymous
Not applicable

Using selections:

Select all products - you get customers who bout at least something.  Now, in customers, select excluded.

Can also do it in expression using set analysis.

MK_QSL
MVP
MVP

Check enclosed file..

PrashantSangle

Hi,

Not sure,

But try this,

Ordered:

Load

Customer_key,

Order_key,

From Ordered;

Customer:

Load

Customer_key as customer

from Customer

where not exists(Customer_key,customer_key)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂