Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

robert2012
New Contributor III

Show dublicates

Hi all,

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

CompanyTicket
München1234
Berlin32423
Bonn1234
Hamburg887878
Nürnberg766328

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

1 Solution

Accepted Solutions

Re: Show dublicates

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

3 Replies

Re: Show dublicates

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

Here it is an example

MVP
MVP

Re: Show dublicates

Try:

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

Community Browser