Pls calrify How to show daywise closing for a value field?

[#1]

Dear all

         Anyone can help me to show daywise closing of a Amount field

for ex Amount

Closing

110

160

335

710

729

i have a field which is showsing daywise closing like that i need to show a daywise closing amount in my qlik view

I used a expression

sum({<Num_Trx_Date={'<=$(=num(vDashboardMaxDate))'},AMISDETAILID={10022000012893},YearEnd_Flag={'Without Year End'}>}BS_Amount)

but i can get result of max of selected date

I Need  the daywise closing pls help me !!!!

Regards

Vignesh

[sushil353]

your issue is not clear

please put some more information..

[#3]

hi sushil

            I have list of  transaction  data field namely amount, i need to calculate closing value from this amount field For each Calandar 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 (is input parameter)

Example  jan 1st closing is 453.15  Feb 2nd closing is 453.15+157.73 = 610.87,  I show you the excel 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 ???

Trx_Date      Amount    Closing(Calculated Field)

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

Regards

Vignesh