Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Leap Year problem

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


Labels (1)
1 Reply
Digital Support
Digital Support

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



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.


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.