Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Digital Support
Digital Support

Re: Leap Year problem

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

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.