field historisation QVD

[zied_ahmed1]

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 (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);