Discussion Board for collaboration on QlikView Layout & Visualizations.
I'm trying to highlight duplicate values in a dimension in the following table
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
I like Bills answer, but it seems to fail if we don't sort on CCode.
This one I think works a bit better
=if(count( Total <CCode> CCode) > 1 , LightGreen())
It tests for a count of total occurrences of a CCode and is not dependent on sort order.
View solution in original post
It is highlighting the first occurrence in the data table based on the order loaded not the order sort in the display table.
Is there a way to highlight all of them, not only first occurrence?
=if(CCode = below(CCode) or CCode = above(CCode) , LightGreen())
This link talks about using the 'Total' syntax