topic Re: How to achieve this ? in QlikView

How to achieve this ?

Anonymous — Fri, 14 Apr 2017 08:33:20 GMT

Hi All,

I have a pivot table where i need to do rolling sum by subproducts..

above is my data set.. and i want to calculate the rolling sum by subproducts..

Thanks in advance.

Regards,

Aashish

MK_QSL — Fri, 14 Apr 2017 09:10:38 GMT

Sum(Aggr(RangeSum(Above(Sum(Value), 0, RowNo())), SubProduct,Product,Year, Month))

FieldNames are case sensitive in QlikView so change according to your application.

i.e. SubProduct to subproduct etc..

Anil_Babu_Samineni — Fri, 14 Apr 2017 09:12:54 GMT

Seems works to me

Sum(Aggr(RangeSum(Above(Sum([Normal Value]), 0, RowNo())), subproduct,Product,Year, Month))

Anonymous — Fri, 14 Apr 2017 09:13:43 GMT

Use aggr( rangesum(above( sum(NormalValue), 0, rowno() )), subproduct, Month) for your rolling sum.