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: 
Not applicable

seeing duplicates across two fields

I have three fields supporter number, last name and postcode. What I am trying to do is to put a condition on the background colour of supporter number to say if the postcode and last name combination appears twice i want the supporter number to be coloured.

I understand where to put this condition but I cannot work out what condition to use

thanks in advance

Rosie

22 Replies
Not applicable
Author

Hi Rosie,

look the attached example. Is what do you need?

Andrea

Not applicable
Author

when the postcode and last name combination are repeated I need for the supporter number to go a different colour

Thanks

Rosie

Not applicable
Author

Hi,

like this?

Andrea

Not applicable
Author

Hi Rosie,

sorry lloking more deep I see that it's not working every time.

I keep looking.

Andrea

Not applicable
Author

Hi Rosie,

now seams to work on your sample data. Take a look in the script where I have created a key field.

Andrea

Not applicable
Author

Thank you very much that has worked!

Rosie

Not applicable
Author

have just gone through all my data to check,as have over 10000 rows but unfortunately have now discovered has not worked

Thanks

Rosie

Not applicable
Author

Can you post the data?

Andrea

Not applicable
Author

no sorry I cannot

Rosie

Not applicable
Author

Ok, just the 3 fields like before but with the 10.000 records?

I just tried out on one table and seams to work.

Andrea