Comulative Opening in Pivot Chart

vijayit43 — Thu, 26 Feb 2015 10:31:11 GMT

Hi Expert,

In QlikView Pivot chart we want to cumulative Opening date wise in a row from a given period, for detail example given bellow

Code Date Amount

cust/001 01/02/2015 5

cust/001 02/02/2015 10

cust/001 03/02/2015 15

cust/001 04/02/2015 20

cust/001 05/02/2015 25

cust/001 06/02/2015 30

cust/001 07/02/2015 35

cust/001 08/02/2015 40

cust/001 09/02/2015 45

cust/001 10/02/2015 50

when we give filter date from 04-02-2015 to 09-02-2015 the show result at this type

Code Date Opening

cust/001 04/02/2015 30

cust/001 05/02/2015 50

cust/001 06/02/2015 75

cust/001 07/02/2015 105

cust/001 08/02/2015 140

cust/001 09/02/2015 185

how to achieve this please suggest

Attached Sample QV Please Suggest..

Re: Comulative Opening in Pivot Chart

Gysbert_Wassenaar — Thu, 26 Feb 2015 10:41:29 GMT

Try sum(aggr(rangesum(above(total sum({<Date=>}Amount),1,rowno())),Date))

See attached qvw.

vijayit43 — Mon, 02 Mar 2015 14:35:28 GMT

Hi Sir,

Please Suggest Sample QV Attached for refrence.

vijayit43 — Tue, 03 Mar 2015 08:14:15 GMT

Hi Sir,

Please Suggest..