https://community.qlik.com/t5/Qlik-Learning-Discussions/Count-ignoring-a-dimension/m-p/1799011#M4329 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/139222">@goddamnoise</a>&nbsp;</P><P>Try like below</P><P>Count: Count(Total&lt;IBAN&gt; IBAN)</P><P>Duplicate: If(Count(Total&lt;IBAN&gt; IBAN) &gt; 1, 'Y', 'N')</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1618305142728.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52875iE3641C94BBBBB53D/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1618305142728.png" alt="MayilVahanan_0-1618305142728.png" /></span></P><P>&nbsp;</P> Tue, 13 Apr 2021 09:13:04 GMT MayilVahanan 2021-04-13T09:13:04Z https://community.qlik.com/t5/Qlik-Learning-Discussions/Count-ignoring-a-dimension/m-p/1799005#M4328 <P>I have this graph where I want to count duplicate bank accounts but ignoring the Efecto. Right now I only manage to count the duplicate accounts on each Efecto. Can somebody help me?</P><P>I am using this:</P><P>Count ({&lt;[Anulado] = {'0'}&gt;} IBAN)</P><P>{&lt;[Anulado] = {'0'}&gt;} = It's another filter I'm using</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021_04_13_10_41_52_Administración_v_4_Mi_nueva_hoja_Hojas_Qlik_Sense.png" style="width: 588px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52873iDDAF1EE536A58845/image-size/large?v=v2&amp;px=999" role="button" title="2021_04_13_10_41_52_Administración_v_4_Mi_nueva_hoja_Hojas_Qlik_Sense.png" alt="2021_04_13_10_41_52_Administración_v_4_Mi_nueva_hoja_Hojas_Qlik_Sense.png" /></span></P> Tue, 13 Apr 2021 08:53:06 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Count-ignoring-a-dimension/m-p/1799005#M4328 goddamnoise 2021-04-13T08:53:06Z https://community.qlik.com/t5/Qlik-Learning-Discussions/Count-ignoring-a-dimension/m-p/1799011#M4329 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/139222">@goddamnoise</a>&nbsp;</P><P>Try like below</P><P>Count: Count(Total&lt;IBAN&gt; IBAN)</P><P>Duplicate: If(Count(Total&lt;IBAN&gt; IBAN) &gt; 1, 'Y', 'N')</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1618305142728.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52875iE3641C94BBBBB53D/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1618305142728.png" alt="MayilVahanan_0-1618305142728.png" /></span></P><P>&nbsp;</P> Tue, 13 Apr 2021 09:13:04 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Count-ignoring-a-dimension/m-p/1799011#M4329 MayilVahanan 2021-04-13T09:13:04Z