Omit Duplicate records from the count.

Mon, 31 Mar 2014 16:46:03 GMT

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

Re: Omit Duplicate records from the count.

Gysbert_Wassenaar — Mon, 31 Mar 2014 16:54:08 GMT

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

Re: Omit Duplicate records from the count.

Mon, 31 Mar 2014 18:18:07 GMT

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

Jasmine

topic Re: Omit Duplicate records from the count. in QlikView

Omit Duplicate records from the count.

Re: Omit Duplicate records from the count.

Re: Omit Duplicate records from the count.