My first post in the community, though having been months with Qlikview.
Just would like to seek some help on how I can count the occurrence of the Value Pairs. For example, I have a table of (x,y) with values: (10,20), (15,30), (10,20), (10,20), (15,20). How can I count the occurrence of each value pair which gives:
(10,20) = 3
(15,30) = 1
(15,20) = 1
Looks simple (I guess) but I cannot find an answer from the community for a whole day search. Maybe I used the wrong keywords. Thanks in advance.
Thank you both. Have been dragging in finding the right expression like Count() and Aggr(), but haven't thought of your advised one. Precise and concise ! Will use it as the 3rd dimension for the bubble size of the Scatter Chart.