Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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