Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

count active records in date ranges

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

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

 

@sunny_talwar

QlikView Qlik Sense consultant
Labels (4)
0 Replies