Leap Year problem

everest226 — Sat, 16 Nov 2024 02:23:25 GMT

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

Re: Leap Year problem

Brett_Bleess — Mon, 07 Oct 2019 18:29:06 GMT

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-comparison/m-p/1273071#M43876

https://community.qlik.com/t5/QlikView-App-Development/leap-year-feb-29-issue-while-joing-with-non-leap-years/m-p/659341#M240525

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

topic Re: Leap Year problem in QlikView

Leap Year problem

Re: Leap Year problem