Discrepancy in data between Qlik tabel and Excel Add-in Export

TerDah — Thu, 10 Jul 2025 10:40:05 GMT

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?

Re: Discrepancy in data between Qlik tabel and Excel Add-in Export

TerDah — Thu, 10 Jul 2025 10:55:36 GMT

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.

topic Re: Discrepancy in data between Qlik tabel and Excel Add-in Export in Integration, Extension & APIs

Discrepancy in data between Qlik tabel and Excel Add-in Export

Re: Discrepancy in data between Qlik tabel and Excel Add-in Export