field historisation QVD

zied_ahmed1 — Mon, 10 Apr 2017 08:43:09 GMT

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

topic field historisation QVD in Management & Governance

field historisation QVD