Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Aggr(Count(FACT), FACT) as [REPEAT RESULT]