Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
yura_ratu
Contributor II

Highlight duplicates in dimension

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

1 Solution

Accepted Solutions
jackhertel
New Contributor III

Re: Highlight duplicates in dimension

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.

5 Replies
jackhertel
New Contributor III

Re: Highlight duplicates in dimension

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
Contributor II

Re: Highlight duplicates in dimension

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

Thanks

Re: Highlight duplicates in dimension

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

See attached.

jackhertel
New Contributor III

Re: Highlight duplicates in dimension

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
New Contributor III

Re: Highlight duplicates in dimension

Community Browser