Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number repeated

How do I get the value of a column that repeated more and more often repeated than less?

3 Replies
swuehl
MVP
MVP

Could you give an example? Some lines of sample data and your expected outcome?

Not applicable
Author

Yes

Col1

10

10

10

10

3

2

2

4

4

5

5

What this column more than less repeated and repeated, in case 10 was the most repeated and repeated was the third least in my case is a column with N possible values ​​there are also like to make a rank of 10 most repeated and 10 less repeated, else the value is among the most repeated have another show number two ...

nagaiank
Specialist III
Specialist III

You can create a listbox for the field and check 'Show Frequency' in the General tab of the listbox property.

Also you can set the sort order in the sort tab as frequency descending/ascending depending on your requirement.