topic Re: Select non duplicate values in field in QlikView

Select non duplicate values in field

Tue, 09 Sep 2014 17:10:46 GMT

I have an inventory number field in a table. I want to select only those inventory numbers that are not duplicates. For example:

Inventory Number
111
112
112
113
115
115
115

Out of the values above I would want to select only 111 and 113. Is there an easy way to do this? Ideally I want a way to do this via a search in a list box containing this field.

Re: Select non duplicate values in field

Gysbert_Wassenaar — Tue, 09 Sep 2014 17:23:30 GMT

Right click the listbox and select advanced search. Then enter the expression =count([Inventory Number])=1 and press the Go button:

Re: Select non duplicate values in field

Tue, 09 Sep 2014 17:31:57 GMT

Thanks!