Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Prior Year Business Days Set Analysis

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

Labels (1)
2 Replies
Highlighted
Contributor
Contributor

I have the same issue. Can someone help please!

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.