Hello,
Got some trouble trying to figure out how to calculate per month and year active records in some contracts.
records can be active within all kind of date ranges.
objectif is to create analytics around active records per month and year and comparisons between N and N-1 periods.
I've managed to calculate per month and year using an island calender as a dimension but this causes big performance issues.
suggestions?![Capture.PNG Capture.PNG](https://community.qlik.com/t5/image/serverpage/image-id/14725iC693EAFB9A08EF22/image-size/large?v=v2&px=999)
please find sample data in attachement.
u will gain my eternal gratitude for help 😅
@sunny_talwar
QlikView Qlik Sense consultant