Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mamta123
Contributor II
Contributor II

Need the count of ID for a particular date. The count should not be affected by any filter

My data has the following columns: ID, Joining Date and Last date

I need to count the no. of attritions,  I have to use the count the no of Ids considering the Max Last Date of the data.

It should not be affected by joining date filter.

 

Labels (1)
4 Replies
Taoufiq_Zarra

can you share a sample data

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Mamta123
Contributor II
Contributor II
Author

This is sample data

IdJoining DateLast Date
11/12/20169/12/2019
132/3/20159/13/2018
126/14/20179/14/2019
21/15/20169/14/2019
35/16/20169/14/2019
147/17/20169/12/2019
59/1/20189/12/2019
61/19/20189/13/2018

 

I need to get the count of attrition on the last date of the month but the count should not show any effect of joining filter

Taoufiq_Zarra

can you also give the output you want on this sample data

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Death4Free
Contributor III
Contributor III

If I understand correctly, you can use measure Aggr(Nodistinct Count({1}Id), [Last Date])

image.png