Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

compare?


Hi

i have 2 xl separeate sheets called

sales.xlsx  and budget.xlsx

but in both sheets no of sheets same and sheet names also same  and inside the sheet field names also same

now my req is i want create sample application to know the difference between these two xl sheets

in xl sheets i have sheet names like

summary

products

conditions

same sheet names i have in another xl sheet also

but inside the data may be different now i want know what is the different data between  2 sheets ?

10 Replies
Not applicable
Author

You can use the QUALIFY for the Qlikview to prefix the column names with the Table(Sales & Budget) or you can rename the identical column names in the Sales.xlsx and budget.xlsx.

For QUALIFY, plz. take a look at the link below

qualify and unqualify

Anonymous
Not applicable
Author

i want  to identify the unmatched data between the excels

terezagr
Partner - Creator III
Partner - Creator III

1. You can use Qualify

2. then Unqualify the primary key

3. Left Join

terezagr
Partner - Creator III
Partner - Creator III

Like this:

Capture1.JPG

And you get this:

Capture.JPG

Anonymous
Not applicable
Author

Hi thanks for the reply

i have 2 separate xl sheets  sales.xlsx  and budget.xlsx

here both sheets contains shhet1 and sheet2

now i want compare between two separate xl sheets different data

dont think both sales and budget are in one xl sheet , both are different

still not understanding pls let me know

pls advice

terezagr
Partner - Creator III
Partner - Creator III

I do not understand your question. Do you have problems loading data from the two sheets within the the sales.xlsx  and two sheets in budget.xlsx?

Go to Load Script ->Table Files-> Select your sales.xlsx sheet-> in File Wizard: Type in Tables drop down select Sheet1 and use embedded labels etc, finish.

Now you have loaded Sheet1 from Sales.xlsx

Same steps apply to all other sheets.

Not applicable
Author

Not clear with your requirement(Unmatched Data). Plz. can you upload the XL files.

Anonymous
Not applicable
Author

Thanks

when i am loading muliple shhets in same excel through for rach loop  like

for each vsheets in 'sheet1','sheet2'

load

*

from ......

it is giving error like biff table cannot located file

and some times unknown file format specifier table

why?

Anonymous
Not applicable
Author

I got this one

now i have loaded a multiple excel sheets through for each loop

now i want  find the unmatched data between these two