Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Generate DATA and grouped PROGRESSIVE TOTAL in script.

Hi everybody!

Don't know how to do this and my head is fully broken because of my task.

There is Sales table like this:

MonthNameCustomerIDMonthSum

jan 2014

1150
feb 20141120
jan 20142180
mar 20142140
feb 20143120

Script is simple:

Tab1:

LOAD

MonthName(date) as Month,

CustomerID,

round(Sum(Sales)) as MonthSum

Resident Orders Group By CustomerID, (MonthName(date));

I need table with no-sales-months and with progressive total field, something like this:

MonthNameCustomerIDMonthSumProgrTotal
jan 20141150150
feb 20141120270
mar 201410270
jan 20142180180
feb 201420180
mar 20142140320
jan 2014300
feb 20143120120
mar 201430120

Hope you have more experience and more stable brains instead of me!

Waiting for your help!!

P. S. I need it in script. I've made the table with progressive total but without no-sales-months)

1 Solution

Accepted Solutions

Re: Generate DATA and grouped PROGRESSIVE TOTAL in script.

See attached qvw.


talk is cheap, supply exceeds demand
2 Replies

Re: Generate DATA and grouped PROGRESSIVE TOTAL in script.

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Generate DATA and grouped PROGRESSIVE TOTAL in script.

Genius!! You helped me a lot!

Community Browser