topic store values day by day in QlikView

store values day by day

Thu, 02 Jul 2015 08:02:02 GMT

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

Re: store values day by day

alexandros17 — Thu, 02 Jul 2015 08:06:41 GMT

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

Re: store values day by day

jagan — Thu, 02 Jul 2015 08:14:29 GMT

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.

Re: store values day by day

Thu, 02 Jul 2015 08:19:08 GMT

Thanks for your answer

Re: store values day by day

Thu, 02 Jul 2015 08:21:18 GMT

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

Re: store values day by day

jagan — Thu, 02 Jul 2015 08:23:11 GMT

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