Highlight duplicates in dimension

[yura_ratu]

Hi all,

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

Any ideas?

Yurii

[jackhertel]

It is highlighting the first occurrence in the data table based on the order loaded not the order sort in the display table.

[yura_ratu]

Is there a way to highlight all of them, not only first occurrence?

Thanks

[Anonymous]

=if(CCode = below(CCode) or CCode = above(CCode) , LightGreen())

See attached.

[jackhertel · Accepted solution]

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.

[jackhertel]

This link talks about using the 'Total' syntax

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/BasicAggregationF...

[schenklm]

The code = if (count (Total <CCode> CCode)> 1, LightGreen ()). Counts the duplicates in the entire database. However, I would like it to only highlight duplicates in QLIKSENSE that still exist with the filtering currently set. Is that also possible? I.e. it should only count those in the count that are currently filtered.

Thanx in advance

MArk