Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ...
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.
Thanks for your answer
Hi thank you, but instead of "TEst" what i got to fill ?
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..