The problem occurs when a field filter is not specified in a LOAD statement that gets data from a .parquet file.
This simple script provides an example where the issue can occur:
TEST:
LOAD *
inline ['docCode','docName','docStatus'
'A1', 'Description A1','S',
'A2', 'Description A2','S',
'A3', 'Description A3','N',
'A4', 'Description A4','N',
'A5', 'Description A5','S',
];
Store TEST into [lib://test (domain_administrator)/test.qvd] (qvd);
TEST:
LOAD
docCode,docName,docStatus
FROM [lib://test (domain_administrator)/test.qvd] (qvd)
WHERE docStatus = 'N';
You get the error message if you remove ,docStatus from the latest LOAD.
The problem does not occur if you store the content in a QVD file.
Resolution
The problem is fixed in Qlik Sense May 2024.
A possible workaround is to specify the docStatus field in the LOAD statement and then drop the field after the filtering, like in this example:
LOAD *
inline ['docCode','docName','docStatus'
'A1', 'Description A1','S',
'A2', 'Description A2','S',
'A3', 'Description A3','N',
'A4', 'Description A4','N',
'A5', 'Description A5','S',
];
Store TEST into [lib://DataFiles/Ptest.parquet] (parquet);
Drop Table TEST;
TEST:
LOAD
docCode,docName, docStatus
FROM [lib://DataFiles/Ptest.parquet] (parquet)
WHERE docStatus = 'N';
Drop Field docStatus;
Cause
The problem is due to a defect in Qlik Sense February 2024.
Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-25080 for reference.
Internal Investigation ID
QB-25080
Environment