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:
DATO | RESULTADO REPETICIONES |
A | 2 |
A | 2 |
B | 3 |
B | 3 |
B | 3 |
D | 1 |
thank you so much
You will need to create a new dimension, not a measure, containing something like this:
=aggr(count([DATO]),[DATO])
You will need to create a new dimension, not a measure, containing something like this:
=aggr(count([DATO]),[DATO])
Thank you very much vincent, already add the new dimension in a qv table and there I can reference the result what I want.