Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

error in QlikView 12

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;

homework

Checked the the variables and they are set ok.

Thanks,

RJ

1 Reply
prieper
Master II
Master II

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