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: 
mario-sarkis
Creator II
Creator II

Read From Diffrent Execl Sheet

Dear all ,

Kindly i need to read from 2 excel sheet , each excel sheet has the target of each year .

The first excel sheet is name Target-2016 and the second is Target-2016 i am using this target on single KPI

How can i read these two sheet without concatenation since i am you going to add a target next year as well.

Thank you.

Hope you can help

3 Replies
migueldelval
Specialist
Specialist

Hi Mario,

You can use qualify to have both excel sheets.

Regards

Miguel del Valle

mario-sarkis
Creator II
Creator II
Author

Hi Miguel ,

Can you clarify what you said please ? or any example ?

Thanks a lot

migueldelval
Specialist
Specialist

Hi Mario,

Your problem, If I´ve understood correctly, it´s that you have two origins with differents values but similar names.

Qualify change automatically names of fields. If you want to know more about it please read this document Do you Qualify?- How to use QUALIFY statement.

Regards

Miguel del Valle de Gracia