topic Re: Prior Year Business Days Set Analysis in QlikView

Prior Year Business Days Set Analysis

ryanfoster84 — Sat, 16 Nov 2024 00:29:21 GMT

Hi,

I am using the following set analysis to calculate the business days Prior YTD:

=Max(
{$<
Year = {$(=max(Year)-1)},
[Trade Date]={"<=$(=AddYears(max([Trade Date]),-1))"},

[Month Name] = {"<=$(=max({<Year={$(=max(Year))}>} [Month Name]))"}
>}
[Business Days YTD])

but i am encountering a problem. When i select May 2020 on my dashboard it is only returning 102 business days for May 2019 but it should in fact be returning 104 and the reason for this because May 2020 only had business days until the 29th May 2020 where as May 2019 had business days running until 31st May hence the 104 business days.

Can anyone assist?

Thanks,

Ryan

Re: Prior Year Business Days Set Analysis

hsalem65 — Fri, 12 Jun 2020 15:17:29 GMT

I have the same issue. Can someone help please!

Re: Prior Year Business Days Set Analysis

Brett_Bleess — Wed, 01 Jul 2020 21:46:12 GMT

With no QVW file and no data model etc., it is going to be very difficult for anyone to really say why things are occurring in this case.

Regards,
Brett