topic Incomplete Data Load Results in Move to Qlik Cloud Analytics

Incomplete Data Load Results

jianne_devilla — Tue, 27 Jan 2026 10:45:26 GMT

There are times when the query results don't match the actual data being loaded into the dashboard. This inconsistency has been affecting the accuracy of the reports. Please see below screenshot for reference:

Query Results: 144,737

Total Number of Rows: 130,495

Do you have any idea how to fully load the 144,737 rows?

Re: Incomplete Data Load Results

rwunderlich — Wed, 09 Jul 2025 17:53:23 GMT

Without seeing more of the script, it's hard to give an opinion. Is there a preceding load before the SQL Select? Is there a subsequent script statement(s) that operates on the GPSdata table?

-Rob

Re: Incomplete Data Load Results

paolo_cordini — Wed, 09 Jul 2025 18:28:39 GMT

Check section access....

Re: Incomplete Data Load Results

jianne_devilla — Thu, 10 Jul 2025 06:27:01 GMT

I tried commenting out the Section Access, and it worked. However, I need it enabled to properly manage user access. Please see below script:

Can you tell me what caused the issue here?

Re: Incomplete Data Load Results

paolo_cordini — Thu, 10 Jul 2025 06:42:18 GMT

Without knowing the data model, is difficult...

Some values of KEY are filtered out by the section access. Maybe there are some NULL values in the field KEY? It should be not difficult to spot the missing KEY values because they will appear without section access