topic Re: Highlight duplicates in dimension in QlikView

Highlight duplicates in dimension

yura_ratu — Thu, 16 Feb 2017 16:53:57 GMT

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

Re: Highlight duplicates in dimension

jackhertel — Thu, 16 Feb 2017 17:17:31 GMT

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

Re: Highlight duplicates in dimension

yura_ratu — Thu, 16 Feb 2017 17:46:08 GMT

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

Thanks

Re: Highlight duplicates in dimension

Anonymous — Thu, 16 Feb 2017 17:53:30 GMT

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

See attached.

Re: Highlight duplicates in dimension

jackhertel — Thu, 16 Feb 2017 18:05:16 GMT

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.

Re: Highlight duplicates in dimension

jackhertel — Thu, 16 Feb 2017 18:09:10 GMT

This link talks about using the 'Total' syntax

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

Re: Highlight duplicates in dimension

schenklm — Tue, 07 Jul 2020 13:04:11 GMT

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