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

Find out repeating ID but different Name (other field)

Dear All

I need to find out cases where in, I have same PASS_NO but different names in Name field.

I am attaching sample data where in I need to find out the Blue colored highlighted records.

The frequency is greater than 1 in most of the entries.

Kindly help. Let me know if more details are required.

Thanks & Regards

Chintan Gala

1 Solution

Accepted Solutions
sunny_talwar

You can try this expression on the front end of the application:

If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, 0)


Capture.PNG

View solution in original post

9 Replies
sunny_talwar

You want this to happen in the script or front end of the application?

sunny_talwar

May be this in the script to flag those PASS NOs

Table:

LOAD [PASS NO],

    NAME,

    ADDRESS

FROM

PASS_repeat.xlsx

(ooxml, embedded labels, table is Sheet1);

Left Join (Table)

LOAD [PASS NO],

  If(Count(DISTINCT NAME) > 1, 1, 0) as Flag

Resident Table

Group By [PASS NO];

Capture.PNG

Anonymous
Not applicable
Author

Dear Sunny

Thanks for your help.

Data is huge so is there anyway to do in front end. I have used similar expression in front end, but it does not pick all the PASS_NO which are repeating for different names.

Thanks & regards

Chintan Gala

sunny_talwar

You can try this expression on the front end of the application:

If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, 0)


Capture.PNG

Anonymous
Not applicable
Author

Thanks a lot Sunny, it works perfectly as required!!  If you can explain the expression a bit in brief.

In my application after applying your expression I get only repeated ones. however in your application u shared we can also see the 0 ones . Have u done any additional settings?

Thanks & regards

Chintan

Anonymous
Not applicable
Author

Hello Sunny

I believe it is Supress zero value check box in Presentation..

mohammadkhatimi
Partner - Specialist
Partner - Specialist

This will work for both NAME and ADDRESS


If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, If(Count(DISTINCT TOTAL <[PASS NO]> ADDRESS) > 1, 1))

Hope this will helps u..!!


Regards,

Mohammad


Anonymous
Not applicable
Author

Thanks Mohammad , this can be used for other additional reports!

sunny_talwar

You are right, I unchecked 'Suppress Zero Values' on the presentation tab to show 0s