Logic for MTD,LMTD,LYMTD,YTD.LYTD

[lalitkgehlot89]

Hi,

I have Product Qty and Product Amount and field Link_Date.

I want to show in chart Sum(Qty) and Sum(Amount) with these Time Frame.

Suppose My Last date is 08-03-2016

1) Month To Date ( Data should be From 01-03-2016 to 08-03-2016)

2) Last Month To Date  ( Data should be From 01-02-2016 to 08-02-2016)

3) Last Year Month To Date  ( Data should be From 01-03-2015 to 08-03-2015)

4) Year To Date  ( Data should be From 01-04-2015 to 08-03-2016)

5) Last Year To Date ( Data should be From 01-04-2014 to 08-03-2015)

Plz help me out to write the expression.

Thanks,

Lalit Kumar

[Chanty4u]

hi chk dis,

Year-over-Year Comparisons

Set Analysis for Rolling Periods

[vikasmahajan]

Hope this helps you .

Vikas

[lalitkgehlot89]

Hi Vikas,

Thanks a lot, this is working for full month.

I need data of last month till date.

1) Month To Date ( Data should be From 01-03-2016 to 08-03-2016)

2) Last Month To Date  ( Data should be From 01-02-2016 to 08-02-2016)

3) Last Year Month To Date  ( Data should be From 01-03-2015 to 08-03-2015)

4) Year To Date  ( Data should be From 01-04-2015 to 08-03-2016)

5) Last Year To Date ( Data should be From 01-04-2014 to 08-03-2015)

[vikasmahajan]

Sorry for misunderstood refer this https://community.qlik.com/message/328412#328412

and YTQ, QTD, MTD and WTD

and Re: YTD/YTD LY, QTD/QTD LY, MTD/MTD LY calculations

Thanks

Vikas

[vikasmahajan]

go through this https://community.qlik.com/docs/DOC-4313

vikas