topic How to Calculate LYMTD in SetAnalysis in QlikView

How to Calculate LYMTD in SetAnalysis

khasimvali85 — Wed, 06 May 2015 09:35:01 GMT

Hi Comunity,

Can anybody suggest me how to find out LYMTD?

i have Date field like RegDate

Re: How to Calculate LYMTD in SetAnalysis

datanibbler — Wed, 06 May 2015 09:37:20 GMT

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

Re: How to Calculate LYMTD in SetAnalysis

Gysbert_Wassenaar — Wed, 06 May 2015 09:40:29 GMT

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:

Re: How to Calculate LYMTD in SetAnalysis

prma7799 — Wed, 06 May 2015 10:21:37 GMT

Please check

YTQ, QTD, MTD and WTD

Re: How to Calculate LYMTD in SetAnalysis

buzzy996 — Wed, 06 May 2015 10:25:21 GMT

try tis,

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

Re: How to Calculate LYMTD in SetAnalysis

prma7799 — Wed, 06 May 2015 10:27:33 GMT

check this

Year-over-Year Comparisons

Re: How to Calculate LYMTD in SetAnalysis

Wed, 06 May 2015 10:33:05 GMT

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