This content has been marked as final. Show 4 replies
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?