topic Re: Generate a report from two other reports in Archived Groups

Generate a report from two other reports

Tue, 22 Jul 2025 17:59:49 GMT

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.

Re: Generate a report from two other reports

Gysbert_Wassenaar — Wed, 19 Mar 2014 15:26:24 GMT

See this discussion: How to compare 2 tables and put non-matching results?

Or maybe this one: Intersection of List box values (it's not only about intersection)

Re: Generate a report from two other reports

Wed, 19 Mar 2014 16:22:37 GMT

I don't really understand and I'm retrieving these records from a MySQL data base using queries. But I want to edit a query on the sheet to exclude some values from another table.

Re: Generate a report from two other reports

Gysbert_Wassenaar — Wed, 19 Mar 2014 16:50:50 GMT

With Qlikview you retrieve data from a source like MySQL and load that data into Qlikviews internal in-memory database. This is done with the select and/or load statements you build in the script editor. Once the data is loaded you can interact with the data using for sheet objects like list boxes and charts. Qlikviews internal in-memory database is not an SQL database. You can't query it with sql statements. So there is no query to edit.

Can you post a sample document with some data so one of us can show you a solution?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Generate a report from two other reports

Thu, 20 Mar 2014 08:08:26 GMT

I have two sheet objects(Table boxes) That have this same column. The column in Table one is Tab1_customer_id and the column in table two is called Tab2_customer_id. I want to create a new sheet object that excludes records from table one. I mean I want to get all customer_ids from table one that are not in table two. Please help.

Re: Generate a report from two other reports

Thu, 20 Mar 2014 09:02:47 GMT

I tried using =if(Match(tot_customer_id,new_customer_id),Null(),tot_customer_id). But still does not give me the exact figure.

Re: Generate a report from two other reports

Gysbert_Wassenaar — Thu, 20 Mar 2014 13:08:59 GMT

Create a straight table chart with dimension Tab1_customer_id and expression

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

Re: Generate a report from two other reports

Fri, 21 Mar 2014 07:15:51 GMT

Hello sorry but this does not run, Whats the p for?

Re: Re: Generate a report from two other reports

Gysbert_Wassenaar — Fri, 21 Mar 2014 09:43:04 GMT

Works for me. See attached example.

The p is for Possible values.

Re: Generate a report from two other reports

Fri, 21 Mar 2014 15:30:02 GMT

I'm really sorry about this but I'm using the free version and I don't have the ability to open any documents again. Please can you copy and paste the solution here again. Thank you.

Re: Generate a report from two other reports

Gysbert_Wassenaar — Fri, 21 Mar 2014 15:34:54 GMT

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)

Re: Generate a report from two other reports

Fri, 21 Mar 2014 15:44:36 GMT

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

Re: Generate a report from two other reports

Fri, 21 Mar 2014 15:46:31 GMT

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