YTD,QTD,MTD,WTD IN Qlik Sense

[scotly-victor]

Hi Qlikers,

I wanted to achieve  YTD,MTD,QTD,WTD for Orderdate .

Below given  is my code ,but it didn't work

=if(DateTemp='YTD',sum({<type={'Order'},Year={$(=Max(Year))},Quarter=,Month=,Week=,OrderDate={"<=$(=Max(OrderDate))"}>}Sales),

if(DateTemp='QTD',sum({<type={'Order'},Year={$(=Max(Year))},Month={$(=max(Month))},OrderDate={"<=$(=Max(OrderDate))"},Week=>}Sales),

if(DateTemp='MTD',sum({<type={'Order'},Year={$(=Max(Year))},Month={$(=max(Month))},OrderDate={"<=$(=Max(OrderDate))"},Week=>}Sales),

if(DateTemp='WTD',sum({<type={'Order'},Year={$(=Max(Year))},Quarter={$(=max(Quarter))},Month={$(=max(Month))},Week={$(=max(Week))},OrderDate={"<=$(=Max(OrderDate))"}>}Sales),

sum({<type={'Order'},Year={$(=Max(Year))},Quarter=,Month=,Week=,OrderDate={"<=$(=Max(OrderDate))"}>}Sales)))))

order date start from apr2014 and end in mar2016

Can any one please help me?

[Pallav]

WTD - Sum({<DateID={"$(='>=' & Date(Weekstart(Max(OrderDate)),'MM/DD/YYYY') & '<=' & Date(Max(OrderDate),'MM/DD/YYYY'))"}>}Sales)

QTD - Sum({<DateID={"$(='>=' & Date(Quarterstart(Max(OrderDate)),'MM/DD/YYYY') & '<=' & Date(Max(OrderDate),'MM/DD/YYYY'))"}>}Sales)

MTD - Sum({<DateID={"$(='>=' & Date(Monthstart(Max(OrderDate)),'MM/DD/YYYY') & '<=' & Date(Max(OrderDate),'MM/DD/YYYY'))"}>}Sales)

YTD - Sum({<DateID={"$(='>=' & Date(Yearstart(Max(OrderDate)),'MM/DD/YYYY') & '<=' & Date(Max(OrderDate),'MM/DD/YYYY'))"}>}Sales)