topic Re: Why are the wrong values loaded from my QVD? in App Development

Why are the wrong values loaded from my QVD?

mmarchese — Sat, 16 Nov 2024 18:37:01 GMT

Am I doing something wrong or is Qlik malfunctioning? Why are the wrong values being loaded into the data model? This is happening with my other QVDs too.

SQL Server (correct values):

QVD (correct values):

Data model (wrong values):

Load statement:

Dim_ScrapTracker: LOAD %scrapTrackerId, [Scrap Tracker] FROM [lib://folder - QVDs/Dim_ScrapTracker.qvd] (qvd);

Update:

I realized Qlik brings in the data correctly if I load this table in isolation or load it first. But if I load the fact table containing that same key field (%scrapTrackerId) first, then the values in this dimension table get shuffled around. This is truly baffling.

Re: Why are the wrong values loaded from my QVD?

marcus_sommer — Wed, 20 May 2020 13:00:56 GMT

How does it look like if you put these fields within a table in the UI?

- Marcus

Re: Why are the wrong values loaded from my QVD?

mmarchese — Wed, 20 May 2020 14:21:26 GMT

@marcus_sommer

It matches the data model.

Re: Why are the wrong values loaded from my QVD?

mmarchese — Wed, 20 May 2020 14:39:15 GMT

Ahhhhh, I figured it out. I put this at the end of the script to be clever and then totally forgot about it:

AutoNumber '%*';

In this case, if the dimension table is loaded first, the auto-numbering of %scrapTrackerId just so happens to match the original numbering of that field, obscuring the fact that AutoNumber was used. In contrast, if the fact table is loaded first, the field ends up with different numbers.

Lesson: Don't be a fool and forget that you used AutoNumber! Disable it before debugging such fields!