https://community.qlik.com/t5/App-Development/Highlight-Duplicates-in-QlikSense-Analytic-Analyse-based-on/m-p/1725755#M55313 <P>please look P() and E() function in set analysis</P><P>it will be help to find your solution</P> Tue, 07 Jul 2020 14:49:27 GMT NitinK7 2020-07-07T14:49:27Z https://community.qlik.com/t5/App-Development/Highlight-Duplicates-in-QlikSense-Analytic-Analyse-based-on/m-p/1725731#M55309 <P>Hi,</P><P>if found severel solutions to identify / highlight duplicate values in the total Datacube (e.g.&nbsp;&nbsp;<SPAN>=if(aggr(count(field),field) &gt; 1, LightGreen())).</SPAN></P><P>&nbsp;</P><P><SPAN>But I havn't found a solution how to highlight duplicates based on the current filter set.</SPAN></P><P><SPAN>E.G. </SPAN></P><P>FIELD1 | FIELD2<BR />a | true<BR />a | false<BR /><STRONG>b | true</STRONG><BR /><STRONG>b | true</STRONG><BR />c | true<BR />d | true</P><P>If the user sets a filter for FIELD2 = true, only the two datasets with FIELD1 = b should be highlighted.<BR />But all the solutions i found so far will also highlight the only displayed dataset with an a.</P><P>Thanx&nbsp;</P><P>MArk</P> Tue, 07 Jul 2020 14:12:51 GMT https://community.qlik.com/t5/App-Development/Highlight-Duplicates-in-QlikSense-Analytic-Analyse-based-on/m-p/1725731#M55309 schenklm 2020-07-07T14:12:51Z https://community.qlik.com/t5/App-Development/Highlight-Duplicates-in-QlikSense-Analytic-Analyse-based-on/m-p/1725755#M55313 <P>please look P() and E() function in set analysis</P><P>it will be help to find your solution</P> Tue, 07 Jul 2020 14:49:27 GMT https://community.qlik.com/t5/App-Development/Highlight-Duplicates-in-QlikSense-Analytic-Analyse-based-on/m-p/1725755#M55313 NitinK7 2020-07-07T14:49:27Z