5 Replies Latest reply: Feb 16, 2017 1:05 PM by Jack Hertel RSS

    Highlight duplicates in dimension

    Yurii Ratushnyi

      Hi all,

       

      I'm trying to highlight duplicate values in a dimension in the following table

       

      QlikView x64 Personal Edition - [C__Users_ratu_Desktop_test.qvw_] 2017-02-16 16.50.12.png

      using this expression for color  if(aggr(count(CCode),CCode) > 1, LightGreen())

       

      but can't see any logic in the way it highlights cells. Sample is attached

       

      Any ideas?

       

      Yurii