Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD

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

5 Replies
gautik92
Specialist III
Specialist III

You can also try

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

krishna20
Specialist II
Specialist II

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
Specialist III
Specialist III

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

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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 ?