getting most occurring values

[ZeinaTr]

Hello, I'm new to qlik

I want a formula that gives me the top 3 values occurring in a specific field.

for example if we have a field named products, in this field we have the word cameras 10 times, laptops 7 times, televisions 6 times, heaters 4 times ... then the result will be as follows:

Cameras

Laptops

televisions

I want a formula that gives me the top 3 repeated values from Higher to lower..

thank you in advance!!

[Gysbert_Wassenaar]

The most practical way is to create a Table object with the Products as dimension and count(Products) as measure. Then set the Products dimension limit value to Top 3.

[ZeinaTr]

I want to view the top 3 products in a tooltip for pie chart and not a table, do you have any idea how to do that