topic Cumulative Value for Previous Month in QlikView

Cumulative Value for Previous Month

Tue, 26 Mar 2013 15:38:41 GMT

Hello to all,

I have a set of data like in the table "Details" of the attached file

where the expression is evaluated with the cumulative value of the

field Sales (SalesPrev).

I would like to create a table "Table1" where there are the cumulative

value of SalesPrev for each customer on the last day of each month

compared with the same value of the previous month.

If I select the value for the previous month last IdMonth (eg mar/12)

the Table1 has a zero value for the previous month to the one selected

in the listbox.

Can someone help me?

How can I do it?

Thank

Gysbert_Wassenaar — Tue, 26 Mar 2013 15:47:37 GMT

Try:

Sum( {<IdMonth=, DateDay={"$(=MonthEnd(addmonths(max(DateDay),-1)))"}>} SalesPrev)

see attached qvw

Tue, 26 Mar 2013 16:08:42 GMT

hi Gysbert,

thank for your response.

I tried your solution, but it not works well.

It 'also incorrect value for the selected month

Thu, 28 Mar 2013 14:40:16 GMT

Thank 1000 Gynsbert,

Now OK

I don't understand the meaning of the "IdMont =,..."

Thank a Lot