topic Re: YTD in QlikView

YTD

Wed, 28 Jan 2015 04:25:06 GMT

HI all how do i calculate YTD by months.

Current iam using the below formula which has monthNo in it .I want it to be by month .

=sum({$<Year={$(=Max(Year))},[MOnthNo]={"<=$(=(Max([MonthNo])"},Month=>}Sales)

This will give me ytd but every time i need to selsct monthno , I want the ytd to be displayed when i selsct month list box .

Anonymous — Wed, 28 Jan 2015 04:37:42 GMT

replace monthno --> Month field which is used for the display

arulsettu — Wed, 28 Jan 2015 04:42:09 GMT

try like this

Sum({<Year=, Month=, Datefiled={">=$(=Num(YearStart(Max(Datefiled))))<=$(=Max(Datefiled))"}>} Sales)