Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewchintan
Creator
Creator

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

qlikviewchintan
Creator
Creator
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

View solution in original post

qlikviewchintan
Creator
Creator
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

qlikviewchintan
Creator
Creator
Author

Hello Sunny

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

mohammadkhatimi
Partner
Partner

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


qlikviewchintan
Creator
Creator
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