Helppppppppp me

Mon, 22 Apr 2013 07:01:41 GMT

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

Re: Helppppppppp me

Mon, 22 Apr 2013 14:12:47 GMT

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)