Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
HI,
Did you check if there are any hidden rows?
Also can you share that excel? if possible to understand your problem