topic Re: MTD PY in QlikView

MTD PY

Anonymous — Thu, 27 Mar 2014 13:19:06 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)

How to do it?

Thank you very much.

Re: MTD PY

MK_QSL — Thu, 27 Mar 2014 13:47:07 GMT

For Current YearMonth

=SUM({<Date = {'>=$(=MonthStart(Today()))'}>}Sales)

For Previous YearMonth

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

Hope this helps...

Re: MTD PY

Anonymous — Thu, 27 Mar 2014 14:44:25 GMT

Thank you so much, it's works)))

The only thing, I took not current date, but Today()-1, since data actual - always yesterday in our reporting.

SUM({<Дата = {">=$(=Date(MonthStart(Today()-1,-12)+1)) <=$(=Date(AddYears(Today()-1,-1)+1)) "}>}[Объем л.])

Sorry for the perseverance, the last question

it's possibly to make of this expression - the flag and upload it to load, then to use as a filter (MTD PY = {1, 0})

Thank you, thank you, thank you

Re: MTD PY

MK_QSL — Thu, 27 Mar 2014 14:48:21 GMT

=SUM({<Date = {'>=$(=MonthStart(Today()-1))'}>}Sales)

For Previous YearMonth

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

Re: MTD PY

Anonymous — Fri, 04 Apr 2014 15:16:46 GMT

Tell, please, one more question: Is it possible to upgrade the MTD PY formulas.

I need to redo 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).

Thanks!

Re: MTD PY

MK_QSL — Fri, 04 Apr 2014 15:29:39 GMT

Can you please create a new thread so that other members will also take part !