Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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