Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
marteodori
Contributor
Contributor

Using countif to count numbers of same line value without any desagregation

Hi everybody, 

I'm trying with the next formula to count when how many lines has the same value in the key figure [Numero Reserva] without any desegregation, but doens't work. Any suggestion?

 'count({<[Numero Reserva]={only([Numero Reserva])}>}[Numero Reserva])'

 

Thanks!

Labels (1)
1 Reply
Taoufiq_Zarra

if you mean how many [Numero Reserva] are duplicated

one solution :

=count({<[Numero Reserva]={"=count([Numero Reserva])>1"}>}distinct [Numero Reserva])

 

output :

for the folow input :

Data:
load * inline [
Numero Reserva
1
1
2
2
3
3
4
5
6
7
8
9
4
];

 

the output is :

Capture.PNG

duplicated [Numero Reserva]: 1,2,3,4=4

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉