topic Re: YTD in QlikView

YTD

stephenedberkg — Wed, 20 Jan 2016 11:19:28 GMT

MTD

=Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month=,Year=>} Aggr(If(Only({1}MonthID) = Max(TOTAL <SKU> MonthID) + Only(TOTAL <SKU> OrderLockPeriod),

Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month,Year=>}Arrivals)), SKU, MonthID))

how to write this MTD expression into YTD?

i want to change the bold font month id into YTD format?

Re: YTD

Chanty4u — Wed, 20 Jan 2016 11:38:17 GMT

chk dis

YTQ, QTD, MTD and WTD

Re: YTD

stephenedberkg — Wed, 20 Jan 2016 11:44:37 GMT

=Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month=,Year=>} Aggr(If(Only({1}MonthID) = Max(TOTAL <SKU> MonthID) + Only(TOTAL <SKU> OrderLockPeriod),

Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month,Year=>}Arrivals)), SKU, MonthID))

change this expression into YTD?

i attach the sample