Leap Year problem

[everest226]

HI i am doing current VS previous year calculation.

Variable -

vDay =Sum(Aggr(Sum(Distinct Month_Day),Month)) 

when i select 2018 and 2019 the vDays will give me 365 days  which is correct 

but when i select  2019 and  2020   or  2016 and  2017 it gives me 394 days

Note when i select 2020 only it gives me 366 which is correct , it seems the leap is not working when i select leap year vs regular year

[Brett_Bleess]

Here are some prior posts on Leap Year problems that may help:

https://community.qlik.com/t5/QlikView-Creating-Analytics/Set-Analysis-Leap-Year-in-previous-period-...

https://community.qlik.com/t5/QlikView-App-Development/leap-year-feb-29-issue-while-joing-with-non-l...

No idea if these are going to help or not, but seem to be a couple of key points on things.  My post will kick this back up in the list again, so someone else may chime in too, but folks may need a QVW as well with this one to see the data model etc. too.

Regards,
Brett