Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to make YTD, MTD, FY.

Hi All,

I have a data model where like example there is one date column

TRDate         ,Sales

01/01/2012    ,4512

01/02/2012    ,1487

Date is upto from Jan - 2012 to current date like 26/10/2012

1. How can i make a chart for the YTD.

2. How can i create a chart like MTD.

3. How can i make char for FY.

etc if you have any other type of the chart according to date field. Please provide help for this quicker will be appreciated.

Thanks & Regards

1 Reply
atafsson
New Contributor III

Re: How to make YTD, MTD, FY.

Hi,

I do like this:

MTD:

sum({$<PeriodCounter = {"$(=Max(PeriodCounter))"},YearCounter = {"$(=Max(YearCounter))"}>} Amount)/-Unit

YTD (the setexcl variable = "=Year=, Month=, Quarter=" ):

sum({$<PeriodCounter = {"<=$(=max(PeriodCounter))"},YearCounter = {"$(=max(YearCounter))"},$(setexcl)>} Amount)/-Unit

Hope it helped

/Axel

Community Browser