error in QlikView 12

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

I have an error in QlikView 12 - Unknown Error

It worked fine in QlikView 11. Here's the script:

set state = DETAIL_TABLE;

tempDETAIL_TABLE:

LOAD

Customer_ID,

MAX([Table End Time]) as TABLE_END,

MIN([Table Start Time]) as TABLE_START

FROM [$(vQVDPath)\$(vDatePath)\$(state).qvd]

(qvd)

WHERE State = 9952 and Customer_ID <> '<BLANK>'

GROUP BY Customer_ID;

Checked the the variables and they are set ok.

Thanks,

Re: error in QlikView 12

prieper — Wed, 26 Sep 2018 14:41:47 GMT

if other variables are ok, the first statement needs apostrophs:

set state = 'DETAIL_TABLE';

Else,

when debugging, what does the code say in the window, is the FROM correct?

Peter