Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
girish2195
Contributor II
Contributor II

Expired license count

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.

0 Replies