Expired license count

girish2195 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have license data of an inspector in which Inspector_ID, Activation_date, Expiry_Date and other fields. Once the license is expired, they may issue new license for the same inspector. So the Inspector_IDs are not unique. How do i get to know the number of inspectors whose license is expired for selected period.

Eg:

ID ActDate ExpDate

1 1 Jan 18 3 Mar 18

2 2 Jan 18 10 Mar 18

3 4 Apr 18 10 Dec 18

1 4 Mar 18 12 Dec 18

if the selected period is Jun 2018, Result should be 1 (ID = 2)

Please do help asap.

Thanks,

Girish.

topic Expired license count in QlikView

Expired license count