Skip to main content
Announcements
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
yura_ratu
Partner - Creator II
Partner - Creator 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
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
jackhertel
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.

yura_ratu
Partner - Creator II
Partner - Creator II
Author

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

Thanks

Anonymous
Not applicable

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

See attached.

jackhertel
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.

jackhertel
Contributor III
Contributor III

schenklm
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