Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MTDO PY (offset)

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.

1 Reply
whiteline
Master II
Master II

Hi

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().