Visual Cue expression

[#1]

Good afternoon, i'm struggling to get a script in the visual cue part of qlikview to work but I cant, here is an example of the data im trying to change

Customer number | Contract ref number

10001111             |  ab01

10001111             |  ab02

15215555             |  ab15

I am trying to highlight the duplicate in red by using the expression :- if(count(distinct([Customer Number])))>'2'

while I understand you cannot have 2 distinct numbers it is represented as 2 or being shown twice if like in the above example thereare more than 2 contract reference numbers. How do I go about doing this?

Kind regards.

Paul.

[jagan]

Hi,

Hope attached file helps you. 

Regards,

Jagan.

[#3]

Thanks for the reply, I see how the script works, but how did you make it red?

[jagan · Accepted solution]

Hi,

Check background expression in Dimension, check attached screenshot.

Regards,

Jagan.

[#5]

Spot on Thanks!