# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Contributor III

## General qlik sense Question

Dear Experts,

we have data as follows :

PROBLEM:

 Date EquipmentID CounterNo Coulmn 4 Column 5 9092022 D123 100 9092022 D124 100 9092022 D126 101 9092022 D126 101 9092022 D129 102 9092022 D130 103 9092022 D131 104 9092022 D131 104 9092022 D132 105 9092022 D134 105

In the above data set some of the counterNo are Repeating, i want to extract the rows having duplicate Counter No but different  EquipmentID, so the result i want is :

RESULT SHOULD BE:

 Date EquipmentID CounterNo Coulmn 4 Column 5 9092022 D123 100 9092022 D124 100 9092022 D132 105 9092022 D134 105

I hope i explain the problem properly.

Looking forward for quick response plaese 🙂

Labels (8)

• ### Variables

5 Replies
Specialist

hi,
you will get the output

data:
'-'&CounterNo as key;
Date,EquipmentID,CounterNo
9092022,D123,100
9092022,D124,100
9092022,D126,101
9092022,D126,101
9092022,D129,102
9092022,D130,103
9092022,D131,104
9092022,D131,104
9092022,D132,105
9092022,D134,105
];

inner Join(data)
key,
count_EquipmentID
Where count_EquipmentID>1;
key,
Count(EquipmentID) as count_EquipmentID
Group by key;
'-'&CounterNo as key,
CounterNo,
12 as j
Resident data;

/*

output:
Date EquipmentID CounterNo
9092022,D123,100
9092022,D124,100
9092022,D132,105
9092022,D134,105

*/

Contributor III
Author

Hi @ajaykakkar93 Thankyou so Much for the Reply. Actually the script you used is little confusing for me, as some of my concepts are not clear, sorry for that. If possible can you please explain the working of this script. it would be a great help.

Again Thank you for the Reply 🙂

Specialist

Hi

Is this the desired output

output:
Date,EquipmentID,CounterNo
9092022,D123,100
9092022,D124,100
9092022,D132,105
9092022,D134,105

Contributor III
Author

@ajaykakkar93  Yes.

Specialist