Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Number repeated

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

3 Replies
MVP
MVP

Re: Number repeated

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

Not applicable

Re: Number repeated

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
Valued Contributor III

Re: Number repeated

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.

Community Browser