4 Replies Latest reply: Apr 23, 2012 11:33 AM by mrpjspencer RSS

    Visual Cue expression

      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.