topic Re: YTD in QlikView

YTD

Wed, 21 Jan 2015 04:49:32 GMT

Hi Everybody,

Actually I am using the formala to get Booking for Current Month Current Year and Iam using the below formula

BOOKING CURMONTH TY(Current Year)

=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>} Booking_Total_Sales)

And for YTD Booking This Year The Formula being used is the below one , I want to know is tihs formula correct , What do we mean by YTD

YTD BOOKINGS TY(Current Year)

=Sum({$<Year={$(=Max(Year))},[Month No]={"<=$(=vCurrentMonth)"},Month=>} Booking_Total_Sales)

Thanks in advance

gautik92 — Wed, 21 Jan 2015 05:27:14 GMT

You can also try

=sum({<Year={$(=Max(Year))},[Month No]={"<=$(=max([Month No]))"}>} Booking_Total_Sales)

krishna20 — Wed, 21 Jan 2015 05:30:53 GMT

Hi Wrestler,

YTD is nothing but gives details about total sales from year starting to the present date.

for your easy explanation try this expression.

=sum({$<year= {'>=$(=Max(YearStart(today())))<=$(=max(monthend(today())))'}>}Booking_Total_Sales)

Regards

Krishna

gautik92 — Wed, 21 Jan 2015 05:34:29 GMT

=sum({<Year={$(=Max(Year))},Transactiondate={"<=$(=max(Transactiondate))"}>} Booking_Total_Sales)

jagan — Wed, 21 Jan 2015 05:38:49 GMT

Hi,

YTD means Year to Date, means getting the value from current year start (jan 1) to till date.

Hope this helps you.

Regards,

Jagan.

Wed, 21 Jan 2015 05:52:59 GMT

HI Gowtham thanks for the reply , But i wanted to know is the YTD formula correct ? becuase iam not getting the right vale .

YTD BOOKINGS TY(Current Year)

=Sum({$<Year={$(=Max(Year))},[Month No]={"<=$(=vCurrentMonth)"},Month=>} Booking_Total_Sales)

Can u please help me with this ?