0 Replies Latest reply: Apr 10, 2017 4:44 AM by Zied Ahmed RSS

    field historisation QVD

    Zied Ahmed

      hello,

      I want to use a QVD who stock all data per date and i have a field named "statut" (have 3 values) who can change everyday,(Mondaythe value can be 0, Tuesday value = 1 and Friday = 2)

      The problem is i will do analyse per month so i want in last month display the most value present in this month

      example :

       

      in April :

       

      there is 15 days the value of this Staut  = 0

                  13 days value of Staut 1

                   03 days value of Statut 2

       

      so in April we will display Statut = 0

       

      and this is the QVD used :

       

      ////*************set the qvd folder path************

      SET vQvdPath=C:\qvdtest;

       

       

      QVD:

       

       

      LOAD * FROM [C:\\qvdtest\QVD.qvd] (qvd) ;//source des QVDs historisés

      Concatenate:

       

       

       

       

      LIB CONNECT TO 'Microsoft_SQL_Server;

      LOAD

          * WHERE  "date"= Today()

           ;

        

      SELECT

      date,

      Statut

      Name,

           last_name

      FROM base.dbo."Table"

       

      // ////*********store QVD**************

      STORE [QVD] into [$(vQvdPath)\QVD.qvd](qvd);