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.