2 Replies Latest reply: Mar 9, 2010 3:39 AM by ORpheus67 RSS

    Issues while trying to assign values to variables

    ORpheus67

      Hello all of you,

       

      I've a minor issue in one of my QV dashboard.
      I load several data from the Mantis Bug Tracker.

       

      I have several dates so i would like, in the load script to assign to a variable the maximum value.

       

      My code is similar to this one:

       

       


      Anomalies:
      LOAD
      ID,
      AssignedTo,
      Reporter,
      Priority,
      ....,
      CreationDate
      FROM [MyFile.csv];

      Dates:
      LOAD DISTINCT CreationDate
      RESIDENT Anomalies
      ORDER BY CreationDate DESC;

      LET vDateSoumissionMax = peek(CreationDate,0,'Dates');


      Anyway, the "vDateSoumissionMax" is not created....

      Can anyone help me?

       

      Thanks a lot !