Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Genius!! You helped me a lot!