topic Re: RangeSum with Aggr in QlikView

RangeSum with Aggr

jolivares — Fri, 11 Sep 2015 02:18:58 GMT

Hi community, i was trying to make this chart, please take a moment and see this...

Re: RangeSum with Aggr

sunny_talwar — Fri, 11 Sep 2015 02:58:23 GMT

I am working with Personal Edition of QlikView, would you be able to share the data source behind the sample application you have shared as well as the expression you are using?

Re: RangeSum with Aggr

prajapatiamar38 — Fri, 11 Sep 2015 10:36:24 GMT

Is that you want

See below attached files.

Re: RangeSum with Aggr

jolivares — Fri, 11 Sep 2015 12:40:08 GMT

No Amarnath, if you see the picture attached, I need a whole sum for each "Prod", in your answer is just without the subtotal.

For Sunny this is the data: Try

T1:

LOAD * INLINE [

Prod, Ped, Pos, Rep, Cant

M1, Pe1, Po1, Re1, 50

M1, Pe1, Po2, Re1, 100

M1, Pe1, Po3, Re1, 100

M1, Pe1, Po4, Re1, 100

M1, Pe1, Po5, Re1, 100

M1, Pe1, Po6, Re1, 100

M1, Pe1, Po7, Re1, 125

M2, Pe2, Po1, Re1, 75

M2, Pe2, Po2, Re1, 100

M2, Pe2, Po3, Re1, 100

M2, Pe2, Po4, Re1, 100

M2, Pe2, Po5, Re1, 100

M2, Pe2, Po6, Re1, 100

M2, Pe2, Po7, Re1, 100

M2, Pe2, Po8, Re1, 100

M2, Pe2, Po9, Re1, 150

M1, Pe3, Po1, Re1, 50

M1, Pe3, Po2, Re1, 100

M1, Pe3, Po3, Re1, 100

M1, Pe3, Po4, Re1, 100

];

Re: RangeSum with Aggr

sunny_talwar — Fri, 11 Sep 2015 13:56:19 GMT

This?

Had to make a slight script change:

T1:

LOAD *,

Ped&Pos as Field;

LOAD * INLINE [

Prod, Ped, Pos, Rep, Cant

M1, Pe1, Po1, Re1, 50

M1, Pe1, Po2, Re1, 100

M1, Pe1, Po3, Re1, 100

M1, Pe1, Po4, Re1, 100

M1, Pe1, Po5, Re1, 100

M1, Pe1, Po6, Re1, 100

M1, Pe1, Po7, Re1, 125

M2, Pe2, Po1, Re1, 75

M2, Pe2, Po2, Re1, 100

M2, Pe2, Po3, Re1, 100

M2, Pe2, Po4, Re1, 100

M2, Pe2, Po5, Re1, 100

M2, Pe2, Po6, Re1, 100

M2, Pe2, Po7, Re1, 100

M2, Pe2, Po8, Re1, 100

M2, Pe2, Po9, Re1, 150

M1, Pe3, Po1, Re1, 50

M1, Pe3, Po2, Re1, 100

M1, Pe3, Po3, Re1, 100

M1, Pe3, Po4, Re1, 100

];

Expression for Total Qty:

=RangeSum(Above(TOTAL Sum(Cant), 0, Aggr(RowNo(), Prod, Field)))

Attaching the qvw for review.

HTH

Best,

Sunny