topic Need to find out duplicate values in a table/chart. in QlikView

Need to find out duplicate values in a table/chart.

Anonymous — Fri, 17 Feb 2012 09:10:35 GMT

Hi,

I have some table where we consider the three differen fields value which is in text and date. If I want to put a condition between all three like if all three fields are same for same passeger that means that ticket is duplicate. And I want to know the ticket number based on all three fields value only if the fields are matching twice or more than that. Could any one please let me know the solution.

EX;_

( route & Passenger & Dateof departure) > 1, that means all the three values are if matching for the same passenger and date of journey and itinary is same that means it should show the duplicate ticket number.

Please help.

Best,

Shubham

Need to find out duplicate values in a table/chart.

CELAMBARASAN — Fri, 17 Feb 2012 09:21:11 GMT

Hi,

Have Ticket number as Dimension.

Expr: If(Count(route & Passenger & Dateof departure)>1,Count(route & Passenger & Dateof departure))

Hope it helps

Celambarasan

Need to find out duplicate values in a table/chart.

Anonymous — Fri, 17 Feb 2012 11:04:32 GMT

Hi Celambarasan,

Thanks for your reply. It's the same coding which I have already applied but not a satisfactory solution for the problem. What I want to see the same ticket details should get selected on other side of table where I have taken all the other relevant fields or details regarding the ticket information. Like all other passenger details in one table. And that table can be exported in excel file to have a look of the passenger details who has paid more than once for the same itin, dep.date. Is that possible, to select all this at other field after applying some code.

Best Regards,

Shubham

Need to find out duplicate values in a table/chart.

CELAMBARASAN — Fri, 17 Feb 2012 11:43:24 GMT

Hi,

Can you attach a image of the solution that you need?

Celambarasan