topic Re: YTD YOY Question in QlikView

YTD YOY Question

datagrrl — Fri, 22 Jun 2018 18:15:12 GMT

I found this article, which was helpful, but not exactly what I need to do.

Set Analysis - YTD Compared with Previous Years (Same Parameter)

I need to find which month is the most recent month we have data for and compare it to the same cumulative total for the year at this time last year.

I am attaching an app I mocked up that should simulate the problem.

The example above would work well if I was updating daily, but the grain of the data is at a month level, and may be delayed a few days, so in early June I might be up to either April or May.

This works well if I had data for the entire year.

Sum({$<Year={$(=Year(Today())-1)},Type={'Sales'}>}Value)-Sum({$<Year={$(=Year(Today()))},Type={'Sales'}>}Value)

Any assistance is appreciated.

Re: YTD YOY Question

boorgura — Fri, 22 Jun 2018 18:31:05 GMT

Please use this expression instead:

='YTD YOY Sales: ' & num(Sum({$<Year={$(=Year(Today())-1)},Type={'Sales'}, Month = {"<=$(=Max({$<Type={'Sales'},Year={$(=Year(Today()))}>}Month))"}>}Value)-Sum({$<Year={$(=Year(Today()))},Type={'Sales'}>}Value))

Re: YTD YOY Question

datagrrl — Fri, 22 Jun 2018 18:35:31 GMT

Thanks...I feel like I was getting close, but that last step was just not working out for me. I also realize I had the original calculation backwards.