Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

count active records in date ranges


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.


please find sample data in attachement.
u will gain my eternal gratitude for help 😅



QlikView Qlik Sense consultant
Labels (4)
0 Replies