Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to provide rank to duplicate values in qlikview

How to provide rank to duplicate values in qlikview

6 Replies
sundarakumar
Specialist II
Specialist II

Do u want to know all the duplicates that exist and the number of times it is existing?

Not applicable
Author

Untill can pls post the answer for this

Not applicable
Author

yes.....i want

sundarakumar
Specialist II
Specialist II

Please find the attached app.Get the data into a straight table, add an expression count(idfield), where idfield-> the field for which you want to find duplicates, this will show the the duplicates as count 2 and so on. Please make your requirement more clear for better understanding.

-Sundar

sundarakumar
Specialist II
Specialist II

Please find the attached app, This is another way of doing it.

Hope this helps.

-Sundar

Not applicable
Author

the document is not open in my pc..........please to give u another way