Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)