Hello,
I'm new to Qlikview and I'm having issue with something : I would like to create a report that presents the value with the most occurences to another value.
Let me explain :
here is the raw data
| Categories | Values |
|---|
| A | 1 |
| A | 1 |
| A | 2 |
| B | 2 |
| B | 3 |
| B | 3 |
I would like to create a report (graphic object / simple table) to display:
| Categories | Values with the most occurences |
|---|
| A | 1 |
| A | 3 |
I'm having trouble calculating the second Row. Could anyone give me a hand?
Thanks a lot
