Identify how many times a record of a field is repeated

[Luiper]

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

[Chanty4u]

Try this

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