Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

store values day by day

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

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Thanks for your answer

Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

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..