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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ymjsama
Contributor
Contributor
‎2020-02-16 01:07 AM

Data upload mistake, Qlikview gives me a data which is not on the original excel

In the original excel data, there is an invoice #223 which is cancelled. However, when I upload the excel on Qlikview, I find qlikview shows me two #223 invoices, one is cancelled,  one is submitted. 

I check the original excel several times, there is no submitted invoice #223 (Each invoice should only has one status). Because Qlikview catches two invoices, all the analysis I did with this invoice shows me incorrect result. 

Can anyone help me to check what's the potential problem here?

377 Views
0 Likes
1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2020-02-16 01:38 AM

HI,

Did you check if there are any hidden rows?

Also can you share that excel? if possible to understand your problem

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
364 Views