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?
