topic Re: Qlikview 12 Issues in QlikView

Qlikview 12 Issues

Wed, 15 Mar 2017 14:24:03 GMT

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;

Re: Qlikview 12 Issues

sunny_talwar — Wed, 15 Mar 2017 14:27:05 GMT

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?

Re: Qlikview 12 Issues

Wed, 15 Mar 2017 15:04:22 GMT

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

Re: Qlikview 12 Issues

sunny_talwar — Wed, 15 Mar 2017 15:11:20 GMT

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