Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Contributor III
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.

View solution in original post

5 Replies
Highlighted
Contributor III
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.

Highlighted
Partner
Partner

Re: Highlight duplicates in dimension

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

Thanks

Highlighted

Re: Highlight duplicates in dimension

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

See attached.

Highlighted
Contributor III
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.

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Highlight duplicates in dimension