4 Replies Latest reply: Jun 2, 2011 6:31 AM by Robert Evason RSS

    Why does this simple script generate an error?!?!?

      Hi all

       

      I am trying to generate a table with load times. For the life of me i can't understand why this generates an error. If i change the Let's to Set's it works, but will not give me the proper start time.

       

      Any ideas??

       

       

      LET vStartTime = Now();

       

      ....running script for about 2 minutes....

       

      LET vEndTime = Now();

       

      LoadTime:

      LOAD 'Stage1' AS Stage, $(vStartTime) AS StartTime, $(vEndTime) AS EndTime AUTOGENERATE(1);

       

      PS I'm running QlikView 9

       

       

      Cheers

      Robbie