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?
