Friday 1 August 2014

YTD in qlikview

=sum({<Year={$(=Max(Year))},MonthNUmber={"<=$(=max(MonthNUmber))"},OrderDate={"<=$(=max(OrderDate))"},Quarter=,Month=>}UnitPrice