Discussion Board for collaboration related to QlikView App Development.
i have a pivot with year and month as dimensions ,
in one of the expressions i try to calculate sum amount of the last / max day of the month, any ideas ?
May be something like this:
FirstSortedValue(Aggr(Sum(Sales), Date), -Aggr(Max(Date), Date))
View solution in original post
Should also work if you have Month and Year as two dimensions instead of one
Thank you Sunny, it worked!
No problem. I am glad I was able to help you