https://community.qlik.com/t5/QlikView/count-active-records-in-date-ranges/m-p/1597854#M456589 <P>Hello,<BR /><BR />Got some trouble trying to figure out how to calculate per month and year active records in some contracts.<BR />records can be active within all kind of date ranges.<BR />objectif is to create analytics around active records per month and year and comparisons between N and N-1 periods.<BR /><BR />I've managed to calculate per month and year using an island calender as a dimension but this causes big performance issues.</P><P>suggestions?<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14725iC693EAFB9A08EF22/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>please find sample data in attachement.<BR />u will gain my eternal gratitude for help&nbsp;<span class="lia-unicode-emoji" title=":grinning_face_with_sweat:">😅</span></P><P>&nbsp;</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a></P> Sat, 16 Nov 2024 03:07:34 GMT kfoudhaily 2024-11-16T03:07:34Z https://community.qlik.com/t5/QlikView/count-active-records-in-date-ranges/m-p/1597854#M456589 <P>Hello,<BR /><BR />Got some trouble trying to figure out how to calculate per month and year active records in some contracts.<BR />records can be active within all kind of date ranges.<BR />objectif is to create analytics around active records per month and year and comparisons between N and N-1 periods.<BR /><BR />I've managed to calculate per month and year using an island calender as a dimension but this causes big performance issues.</P><P>suggestions?<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14725iC693EAFB9A08EF22/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>please find sample data in attachement.<BR />u will gain my eternal gratitude for help&nbsp;<span class="lia-unicode-emoji" title=":grinning_face_with_sweat:">😅</span></P><P>&nbsp;</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a></P> Sat, 16 Nov 2024 03:07:34 GMT https://community.qlik.com/t5/QlikView/count-active-records-in-date-ranges/m-p/1597854#M456589 kfoudhaily 2024-11-16T03:07:34Z