First occurrence by sorting

[Anonymous]

Hi All,

Is it possible to sort the values and get the first occurrence in Qlikview?

My requirement is this. I have to sort the names and one more column called Status in desc and get the first occurrence. Is this possible?

QNUm	Name	Status
1000	ABC	Yes
1000	ABC	No
12000	XYZ	No
12000	XYZ	No
12000	XYZ	Yes
200	DEF	N/A
200	DEF	Yes
100	IJK	Yes
10	KLM	No

From this table i should get the following result:

QNUm	Name	Status
1000	ABC	Yes
12000	XYZ	Yes
200	DEF	Yes
100	IJK	Yes
10	KLM	No

Is this possible?

Thanks,

Anupama Jagan

[Anonymous]

I will rephrase my question:

I have few fields in my report and when i recently added one field we are getting multiple rows for the same name.

In order to eliminate the duplicates we thought of sorting by the name asc and status desc and getting the first occurrence.

We have more than 20 to 30 fields in the table as of now.

Kindly let me know how to go about this.

Thanks,

Anupama Jagan