How to store the expression in a table or qvd

[#1]

Hello Good Evening,

How to store the expression values to a date, lets take my today's date is 28/11/2011 --> and expression is Sum(Sales) and Count (Invoice).

Result : 28/11/2011, 500000, 101012

Thanks

Joe

[miikkaqlick]

If your expressions are simple, like sum(Sales) or count(Invoice), do it in script:

History:

Load

     *

From History.qvd;

Concatenate

Load

     Date(Today(),'YYYYMMDD') as Date,

     Sum(Sales) as Sales,

     Count(Invoice) as Invoices

Resident Fact;

Store History into History.qvd (qvd);

You can also write something like this:

Let v_Date = Today();

History:

Load

     Date(Today(),'YYYYMMDD') as Date,

     Sum(Sales) as Sales,

     Count(Invoice) as Invoices

Resident Fact;

Store History into $(v_Date)History.qvd (qvd);

BR

Miikka