Highlight Duplicates in QlikSense Analytic (Analyse) based on current filters

[schenklm]

Hi,

if found severel solutions to identify / highlight duplicate values in the total Datacube (e.g.  =if(aggr(count(field),field) > 1, LightGreen())).

But I havn't found a solution how to highlight duplicates based on the current filter set.

E.G.

FIELD1 | FIELD2
a | true
a | false
b | true
b | true
c | true
d | true

If the user sets a filter for FIELD2 = true, only the two datasets with FIELD1 = b should be highlighted.
But all the solutions i found so far will also highlight the only displayed dataset with an a.

Thanx 

MArk

[NitinK7]

please look P() and E() function in set analysis

it will be help to find your solution