Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Luiper
Contributor II
Contributor II

Identify how many times a record of a field is repeated

Good day,

Can someone help me tell me which function to use in the script to identify the times a record of a field is repeated, for example I have the following table and I want the qlikview to count how many times the records of the data field are repeated and as a result tell me the times of repetitions of each of the records:

DATO RESULTADO REPETICIONES
A 2
A 2
B 3
B 3
B 3
D 1

 

thank you so much

1 Solution

Accepted Solutions
vincent_ardiet_
Specialist
Specialist

You will need to create a new dimension, not a measure, containing something like this:
=aggr(count([DATO]),[DATO])

View solution in original post

2 Replies
vincent_ardiet_
Specialist
Specialist

You will need to create a new dimension, not a measure, containing something like this:
=aggr(count([DATO]),[DATO])

Luiper
Contributor II
Contributor II
Author

Thank you very much vincent, already add the new dimension in a qv table and there I can reference the result what I want.