topic Re: Historization with QVD in Management & Governance

Historization with QVD

zied_ahmed1 — Thu, 06 Apr 2017 09:08:36 GMT

Hello,

I used a QVD to stock all data :

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

Now i need the historization of the Statut result per month.

how i can do it thank you

Regards

Re: Historization with QVD

vlad_komarov — Fri, 07 Apr 2017 13:42:29 GMT

If I understand you correctly, you need to have the report of the Statut field per month, correct?

If so, just extract the Month from your Date field in the script:

SELECT

date,

Month(date) & '-' & Year(date) as MonthYear,

Statut,

......

FROM base.dbo."Table"

And create a chart using MonthYear as dimension and needed aggregate function (Count, Sum, Max, etc of Statut) as Measure:

sum(Statut), for example....

Regards,

Vlad

Re: Historization with QVD

beck_bakytbek — Fri, 07 Apr 2017 14:07:45 GMT

Hi Zied,

if i understand right, with historization: you can save your qvd's in this way:

for instance:

let vFileDate = Date(Today(),'DD-MM-YY');

yout table:

load

...

from your source

and store into test $(vFileDate).qvd(qvd)

i hope that helps

beck

Re: Historization with QVD

zied_ahmed1 — Mon, 10 Apr 2017 08:02:32 GMT

Hello every body i want to stock the value of the Statut everyday...for example the Statut of today is 1 tomorrow is 2 so i need to have 2 rows of statut and not crush the previous Statut

Re: Historization with QVD

satheshreddy — Mon, 10 Apr 2017 08:10:38 GMT

Hi Zied,

use incremental load and use where notexit(Statut)

Regards

Sathish

Re: Historization with QVD

zied_ahmed1 — Mon, 10 Apr 2017 08:19:28 GMT

Hello everybody :

For 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

hope you understand me