topic YTD Set Analysis, Not Working in QlikView

YTD Set Analysis, Not Working

marcus_steggall — Sat, 16 Nov 2024 04:09:24 GMT

Hi team, happy friday

I am having a moment, with a simple calculation that doesn't seem to work.

As per attached qvw, you'll note i've a simple vMaxDate calculation basically trying to sum up previous months within the current year (this has worked previously, but for some reason not anymore)

The month column is working fine, but I'd expect the YTD column to sum up both Jan and Feb months.

So taking 2019, Feb is 6.5m and the total is 32.5 which should be in the YTD column

Can you see where I am going wrong?

Appreciate any advice, cheers

Re: YTD Set Analysis, Not Working

tresB — Fri, 15 Mar 2019 11:03:36 GMT

Change in variable

vMaxDate =date(max(Period_Start),'DD/MM/YYYY hh:mm:ss')

Expression- replace single quote with double

=SUM({<Year_YYYY={'$(vMaxYear)'},Period_Start={"<=$(vMaxDate)"}>}Revenue)

Re: YTD Set Analysis, Not Working

marcus_steggall — Fri, 15 Mar 2019 11:25:27 GMT

awesome, many thanks for that
always something so simple, left out or format
have a great weekend