topic Add rolling month values in a QVD script in QlikView

Add rolling month values in a QVD script

Mon, 06 Feb 2012 16:17:44 GMT

Hi,

I need to create a QVD for one developer calculating rolling month aggregate values.

The mapping of the QVD is :

IDField1,

IDField2,

Day,

Day_Quantity_Value,

Rolling_Month_Quantity_Value

Rolling_Month_M-1-Quantity_Value

Do you have any idea about the way to do it ?

I know this can be easily done in the chart expressions using set analysis but I need to have it already calculated in the qvd.

Thank you very much.

Younes

Add rolling month values in a QVD script

Tue, 07 Feb 2012 08:39:15 GMT

Hi,

For your information and to precize my need :

1) in the DB I have a tab with the daily data (IdField1, IdField2, Day, Day_Quantity_Value)

2) I have a solution using a loop (for each row I sum the data in the DB table). Solution is OK but the performance is really awful (15 hrs processing for 55 000 rows.... !!!!)

If you have any idea, that would really be helpful