Discussion Board for collaboration on QlikView Scripting.
So I have table containing a list of products per customer and a status
What I want to is count by status and customer by wanted a rolling total.
Example Raw Table
I've been trying to use AutoNumbers but I couldn't get it do work
autonumber(alt(Number,'NA'),AccountKey)-1 as Serial
,autonumber(alt(CategoryFull,'NA'),AccountKey)-1 as SerialCategoryFull ,autonumber(alt(CategoryPEO,'NA'),AccountKey)-1 as SerialCategoryPEO