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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Akuma2025
Contributor
Contributor

creating a new table with fields which come from more than 2 different tables

Hi,

i need to try and compare 2 datasets, abit like vlookup in excel.

The 1st dataset is an excel spreadsheet. which is a data entry spreadsheet, which includes, admission date, staff member, customer id, customer name etc

the 2nd dataset is a combination of different tables, which contain multiple fields. To explain further, dataset 2 is a combination of one table which includes; date of admission, recorded by staff member, and then another table, includes customer id, customer name etc. So information is coming from more than 2 tables.

Because the 2nd dataset is a combination of more than 3/4 tables.

i managed to get the information on a sheet table, so the data from one dataset is on one sheet and data from the 2nd dataset is on another sheet.

I now need to know how to compare these 2 sheets of data, and see what is missing from each one.

How do i try and compare if a customer from dataset 1 is and isnt on dataset 2 and the other way, how do i compare if a customer from dataset 2 is and isnt on dataset 1?

any help will be greatly appreciated.

Qlik Sense Desktop 

 

Labels (1)
3 Replies
Anil_Babu_Samineni

Did you explore Exists - script function | Qlik Sense on Windows Help

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Akuma2025
Contributor
Contributor
Author

hi, 

are you able to give me an example on how exist would work for me?

Anil_Babu_Samineni

you can share sample dataset to check, so that we will have a look and share the sample script for you to turn on. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful