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