How to Calculate LYMTD in SetAnalysis

[khasimvali85]

Hi Comunity,

Can anybody suggest me how to find out LYMTD?

i have Date field like RegDate

[datanibbler]

Hi,

if you use the formula Monthstart(Today(), -12) -> that will give you the start of this month 12 months back.

Likewise, the formula Yearstart(Today(), -1) will give you the start of the year, one year back.

HTH

[Gysbert_Wassenaar]

I'm afraid that this question has a thousand right answers. You'll have to post more information to get the correct one. Please post a qlikview document with enough data to answer your question. Perhaps these two documents will help:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[prma7799]

Please check

YTQ, QTD, MTD and WTD

[buzzy996]

try tis,

=num(sum({$<Year = {$(=only(Year) - 1)}>} LineSalesAmount), '$#,##0;($#,##0)')

[prma7799]

check this

Year-over-Year Comparisons

[#7]

Using a master calendar with the relevant flags will make these types of comparisons much simpler.

Have a look at

Calendar with flags making set analysis so very simple

hope that helps

Joe