# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor III

## YTD,QTD, MTD

I am using the some basic training exercises in the Sales Discovery app that comes with Qlik sense.  I am trying to figure out how to calculate YTD, MTD, and QTD sales.   Can anyone help?

Tags (2)
4 Replies
Contributor III

## Re: YTD,QTD, MTD MVP

## Re: YTD,QTD, MTD

Can you share where exactly are you trying to do this and what exact issue you are running into?

Contributor II

## Re: YTD,QTD, MTD

Hi Mark,

you can refer following straightforward set expressions to calculate YTD MTD & QTD

YTD

= sum({< CalDate= {">=\$(=Date(YearStart(max(CalDate))))<=\$(=max(CalDate))" }, CAL_Week= , CAL_Quarter=, CAL_Month= >} Sales)

MTD

=Sum({<
CalDate= {">=\$(=Date(MonthStart(Max(CalDate))))<=\$(=max(CalDate))"},CAL_Week= ,CAL_Year=, CAL_Quarter=>}Sales)

QTD

=sum({<CalDate={">=\$(=QuarterStart(max(CalDate)))<=\$(=max(CalDate))"},CAL_YEAR=,CAL_Month=,CAL_Quarter=,CAL_Day=>}Sales) MVP & Luminary

## Re: YTD,QTD, MTD

Which training materials specifically are you using?  QS 3.2 allows the creation of "Calendar Measures" by right-clicking the "Sales Amount" field in the Fields Assets.  However, the Sales Discovery app that I have with 3.2 Desktop was not properly setup for this. Do you have the source files to be able to reload it?

-Rob