store values day by day

[#1]

Hello

I have a qvw file with several tables who are linked.

I done a dynamic board by client, for a value called "total dev soc" (see attached file please) which is the add of several fields of differents tables.

This values changes everyday and that i want is to store this value to have a historic at the end of the day.

The goal is to do a mean of the last 10 days.

Is it possible? how to store values?

Thanks a lot

and sorry for my bad english

[alexandros17]

If values comes from a single table you can create a daily qvd to store data but if your expression is a combination of more than one field from more than one table than you must use a macro to export your table in Excel then loading (daily) that Excel into your document ...

[jagan]

Hi,

While loading in sccript you can store the Data in QVD like below

LET vToday = Date(Today(), 'YYYYMMDD');

QVTableName:

LOAD

* INLINE [

TEst];

STORE QVTableName INTO [QVTableName_$(vToday).qvd];

Everyday it will create a new QVD with  date file name.

Regards,

jagan.

[#4]

Thanks for your answer

[#5]

Hi thank you, but instead of "TEst" what i got to fill ?

[jagan]

Hi,

Replace

QVTableName:

LOAD

* INLINE [

TEst];

with your

Actual script SQL SELECT OR LOAD statement.

Hope this helps you.

If you got the answer close thsi thread by Correct and Helpful answer.

Regards,

Jagan..