topic Re: Show dublicates in QlikView

Show dublicates

Anonymous — Tue, 06 May 2014 06:58:28 GMT

Hi all,

I have a problem and don't get a simple idea. Hope you can help:

Company	Ticket
München	1234
Berlin	32423
Bonn	1234
Hamburg	887878
Nürnberg	766328

My aim is to get the tickets which have two or more companies.

In the case I would like to see 1234 in one list box and both cities in another list box. It works if you know the ticketnumber. But can you also show only these tickets which have two or more companies in a list box?

If you need more information, just ask.

Thank you for helping!

Robert

Re: Show dublicates

kaushiknsolanki — Tue, 06 May 2014 07:04:07 GMT

Hi,

What you can do is, create list box for tickets, go to properties -> expression ->

Here add expression as count(distinct Company)

Go to sort

Add expression Count(Distinct Company) Descending order.

Apply and OK.

Now you will see the tickets which have more than one company on top and then others.

By doing this you will know which tickets has the most unique companies.

Regards,

Kaushik Solanki

Re: Show dublicates

alexandros17 — Tue, 06 May 2014 07:07:21 GMT

Here it is an example

Re: Show dublicates

tresB — Tue, 06 May 2014 07:07:36 GMT

Try:

=Aggr(If(Count(Company)>1,Ticket),Ticket)