Helppppppppp me

[#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

[#2]

Why do you wanna use string characters with a num date? Otherwise i would just make a variable called vMaxDate

and say LET vMaxDate = Max(yourdate)

and then sum({Date_field={$(vMaxDate)}, OtherFields, BS_Amount)