Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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]