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?