Discrepancy in data between Qlik tabel and Excel Add-in Export
I have a challenge I can’t figure out. I created a sheet in Qlik with a table that contains a range of information. Two of the fields are called BilagNr and RegistreringsNr. BilagNr is unique to the transaction, and RegistreringsNr is the license‐plate number linked to that transaction.
When I view the table in Qlik, the row with BilagNr 116455 shows RegistreringsNr YF125, which is correct according to the database. But when I use the Excel Add-in to export a report based on this same table, the same BilagNr 116455 comes out with a completely different RegistreringsNr (AY464).
Why is the Excel Add-in returning the wrong RegistreringsNr?
I found the error. The mistake on my part was that I combined two tables from Qlik into one table in Excel. This caused the sorting to be incorrect and the data didn’t align properly. It's important to make sure you create a single table in Qlik that contains all the data you want to use in Excel.
I found the error. The mistake on my part was that I combined two tables from Qlik into one table in Excel. This caused the sorting to be incorrect and the data didn’t align properly. It's important to make sure you create a single table in Qlik that contains all the data you want to use in Excel.
