MTDO PY (offset)

Anonymous — Fri, 04 Apr 2014 15:48:29 GMT

Good day!

Please help)

I want to create a flag that will help us analyze the period in last year.

For example, today week №13, Thursday, 27 , the data relevant to the 26.

Need to analyze the period in last year starting on week №13, Thursday and 26 days ago.

This year, I analyze the MTD (1.03.14-26.03.14)

In the previous year - MTD PY (2.03.13-27.03.13)

While working with the formula;

SUM ({<Date = {"> = $ (= Date (MonthStart (Today () -1, -12) +1)) <= $ (= Date (AddYears (Today () -1, -1) +1)) "}>} Sales).

But I need to upgrate formula. On the last day of the month formula should capture all MTD PY

I mean, when our report will be actual to 31 March 2014, the previous year we should take the period 1 -31 March.

During the month analyze the period via SUM ({<Date = {"> = $ (= Date (MonthStart (Today () -1, -12) +1)) <= $ (= Date (AddYears (Today () -1, -1) +1)) "}>} Sales).

How to do it?

Thank you very much.

Re: MTDO PY (offset)

whiteline — Fri, 04 Apr 2014 18:54:07 GMT

Why don't you want to build your date logic in the data model since it isn't dynamic ?

I think you can use two expressions with if() condition using MonthEnd().

topic MTDO PY (offset) in QlikView

MTDO PY (offset)

Re: MTDO PY (offset)