Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
goddamnoise
Contributor
Contributor

Count ignoring a dimension

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?

I am using this:

Count ({<[Anulado] = {'0'}>} IBAN)

{<[Anulado] = {'0'}>} = It's another filter I'm using

 

 

2021_04_13_10_41_52_Administración_v_4_Mi_nueva_hoja_Hojas_Qlik_Sense.png

Labels (1)
1 Reply
MayilVahanan
MVP
MVP

Hi @goddamnoise 

Try like below

Count: Count(Total<IBAN> IBAN)

Duplicate: If(Count(Total<IBAN> IBAN) > 1, 'Y', 'N')

MayilVahanan_0-1618305142728.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.