We are in process of upgrading all our Qlikview 8.2 application to version Qlikview 8.5 for one of our customer.
When we tried to reload one of our applications in Qlikview 8.5, Qlikview has prompted an error 'Field Not Found'
Then we tried to pull the data from data source i.e. Excel, I found a difference in the load script for the latest version (i.e. Qlikview 8.5) from previous version (i.e. Qlikview 8.2) which is pasted below.
Even I have tried with the latest version i.e. Qlikview 9.0. It also prompted the same error.
I'm attaching the file which has problem while pulling data into Qlikview using 8.5 and 9.0 version.
Below are the scripts attached for your reference which has been pulled using different version of Qlikview.
Fields to be noticed-->[Dom ], [Dom 1], [Dom 2].
Qlikview 8.2
LOAD TRY,
Cntl,
Can,
Ros,
[Can %],
[Dom ],
[Dom 1],
[Dom 2],
[PAN %],
Total,
Dom,
Dom1
FROM (biff, embedded labels, table is [Sheet1$]);
Qlikview 8.5
LOAD TRY,
Cntl,
Can,
Ros,
[Can %],
Dom¬
Dom±,
Dom²,
[PAN %],
Total,
Dom,
Dom1
FROM (biff, embedded labels, table is Sheet1$);
Qlikview 9.0
LOAD TRY,
Cntl,
Can,
Ros,
[Can %],
Dom¬
Dom±,
Dom²,
[PAN %],
Total,
Dom,
Dom1
FROM
(biff, embedded labels, table is Sheet1$);
I posted this issue to Qliktech and waiting for reply [8-)]