Hi all

Tue, 23 Apr 2013 09:36:17 GMT

Dear all

I have list of transaction raw data field namely amount, i need to calculate closing value from this amount field For each day, Closing value formula is opening Amount + all transaction Amount = closing Amount

My query is how to write expression to get closing value

i have fields

Amount

Trx_Date

Select_date (Input parameter)

raw data

Example jan 1st closing is 453.15 Feb 2nd closing is 453.15+157.73 = 610.87, I just show you the raw data, between 1 jan to 2nd feb no data if i select

feb 2 need to show 610.87 then if i select 7th apr need to show 57.75

how to write expression to get closing ???

Date Amount Closing

1-Jan-12	453.15	453.15
2-Feb-13	157.73	610.87
3-mar-13	-6.14	604.74
4-apr-13	12.87	617.61
5-apr-13	-169.68	447.93
6-apr-13	-34.16	413.78
7-apr-13	-356.03	57.75
8-apr-13	-282.44	-224.70
9-apr-13	-18.45	-243.14
10-apr-13	-204.31	-447.46
11-apr-13	272.18	-175.28
12-apr-13	130.99	-44.29
13-apr-13	311.19	266.90
14-apr-13	112.55	379.45

Re: Hi all

Tue, 23 Apr 2013 10:26:11 GMT

"Hi all" is not an optimal choice for the subject of a question, maybe you want to change that.

Re: Hi all

jagan — Tue, 23 Apr 2013 10:45:03 GMT

Hi Vignesh,

PFA file for solution.

Regards,

Jagan.

topic Re: Hi all in QlikView

Hi all

Re: Hi all

Re: Hi all