Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
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

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

6 Replies
Highlighted
Contributor III
Contributor III

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

Partner
Partner

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

Thanks

Highlighted

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

See attached.

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor
Contributor

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