Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
RJ
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