Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to provide rank to duplicate values in qlikview
Do u want to know all the duplicates that exist and the number of times it is existing?
Untill can pls post the answer for this
yes.....i want
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
Please find the attached app, This is another way of doing it.
Hope this helps.
-Sundar
the document is not open in my pc..........please to give u another way