Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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:

FACT REPEAT RESULT
A 2
A 2
B 3
B 3
B 3
D 1

thank you so much

1 Reply
Chanty4u
MVP
MVP

Try this

 

    Aggr(Count(FACT), FACT) as [REPEAT RESULT]