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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Aditya_Chitale
Specialist
Specialist

Mismatching values when data loaded from excel into qlik sense

Hi all,

when I load data from an excel sheet, it shows different values for some fields even though I am pulling the sheet directly from the source without applying any formulas.

in the below excel sheet the planned completion%  for Testcase ID.No : GSAP-OQ3-02 (3rd row) is 62.50%

whereas, in the qlik data it shows 37.50% for the same Testcase ID.No

 

ps: when I copy the same table into a new excel sheet, and load it into qlik sense, it shows correct value

 

could there be an issue with the original excel file ?

 

excel sheet: 

RTA.JPG

 

Qlik Data:

qlikData.JPG

 

3 Replies
Anil_Babu_Samineni

I know you are the developer, But sometime we fail. Check If You've loaded proper Excel into Qlik or not? 

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
Aditya_Chitale
Specialist
Specialist
Author

It's the same file. I also checked whether the path is correct or not but nothing seems to work. Could there be an issue with the excel ?

Anil_Babu_Samineni

If you want, we can test for that try to attach Files

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