Omit Duplicate records from the count.

[#1]

Hi Qlikview Developers,

I have a data set which contains a lot of duplicates, I want to eliminate the following IDs (in red) where the Status is Complete. (the metric is to count Register or In Progress status, but the data also duplicate ID with different status, if they are complete, those ID shouldn't be count.). Please advise.

ID	Status
YC08840	Registered
YC08840	Completed
ZC74099	Completed
ZC74099	In Progress
AA31556	In Progress
AA36012	In Progress
AC13687	Registered
AC24267	In Progress
AF88896	In Progress
AG12218	In Progress
AG48265	In Progress
AG51567	In Progress
AH00447	In Progress

Please advise.

Thanks,

Jasmine

[Gysbert_Wassenaar · Accepted solution]

Try count({<ID=e({<Status={Completed}>}ID)>}distinct ID)

[#3]

It works! Thank you so much for your quick response.

Jasmine