Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Generate a report from two other reports

Hello

On my sheet I have two table boxes that have the exact same columns. However, the data in these boxes are different. I'm trying to generate a new Table box that gets the differences between the two table boxes. That is show me in another box what is in the first box that is not in the second box. In SQL its like SELECT ID FROM A WHERE A.ID NOT IN (SELECT ID FROM B). Please is this possible? Thanks.

12 Replies
Gysbert_Wassenaar

Sure no problem. Here goes:

Create a straight table chart with dimension Tab1_customer_id and expression

=sum({<Tab1_customer_id  /= p(Tab2_customer_id)>}1)


talk is cheap, supply exceeds demand
Not applicable
Author

It works. THANK YOU. I'm really grateful.

Not applicable
Author

Thank you so much but It takes alot of time too load. Like its really slow. ANything I can do?