Qlik Community

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.
m_perreault
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
m_perreault
Contributor III

Re: YTD,QTD, MTD

Hey Sunny can you please help stalwar1

Re: YTD,QTD, MTD

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

md_qlikview
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
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

http://masterssummit.com

http://qlikviewcookbook.com

Community Browser