Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rank by frequency

Hi,

I am fairly new to Qlikview.

I was wondering if there is a way to rank top ten items by frequency of them.

For example, in a multibox, after I select a few fields I want it to lists the frequency of each thing in the item field and show the top 10 near the top of the multibox.

Is there a way to do this?

Thanks for your help!

Labels (1)
1 Reply
isaiah82
Creator III
Creator III

Hi Sarina - the attached QVW may give you some ideas for sorting in a list/multi-box. If you're using QV10 the list box can display the frequency using the count() function. Let me know if this isn't what you're looking for.

-Isaiah