Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
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