Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting an error that says "Unknown Error" when my script tries to execute the following. This script worked in Qlikview 11 but fails in Qlikview 12
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;
You have a lot of variables, have you checked if all those variables are still evaluating correctly and then path that is used does include a qvd file?
I would have tested that, however it is actually a client of mine running the new version and I am not with them at the moment. I stepped through the program and the variables are set correctly
just by looking at the code, nothing stands out to me. In addition, I have not heard any issue with running script from QV11 to QV12. Not entirely sure what might the issue be