Need help on YTD

[abubakarsiddiq7]

i have only Month field in my data source (csv)  and month values are like Jan,Feb,Mar,Apr....Dec .

for this how to implement YTD . can any one can help .

EXP: =sum({$<[Month]={'>=$(=month(YearStart(Today())))'}>}aggr(avg([Target ]),[Sold-To ]))

[sergio0592]

Hi,

Take a look here

https://community.qlik.com/t5/QlikView-Documents/YTQ-QTD-MTD-and-WTD/ta-p/1489245

[vikasmahajan]

I think you need 2 expressions 

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} [Sold-To ])

AVG({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} [Target ])

Vikas