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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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

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.