Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
alexandros17
Partner - Champion III
Partner - Champion III

Here it is an example

tresesco
MVP
MVP

Try:

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