topic Re: Number repeated in QlikView https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332024#M1171953 <HTML><HEAD></HEAD><BODY><P>You can create a listbox for the field and check 'Show Frequency' in the General tab of the listbox property. </P><P>Also you can set the sort order in the sort tab as frequency descending/ascending depending on your requirement.</P></BODY></HTML> Tue, 03 Jul 2012 17:26:34 GMT nagaiank 2012-07-03T17:26:34Z Number repeated https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332021#M1171950 <HTML><HEAD></HEAD><BODY><P>How do I get the value of a column that repeated more and more often repeated than less?</P></BODY></HTML> Tue, 03 Jul 2012 17:18:47 GMT https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332021#M1171950 2012-07-03T17:18:47Z Re: Number repeated https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332022#M1171951 <HTML><HEAD></HEAD><BODY><P>Could you give an example? Some lines of sample data and your expected outcome?</P></BODY></HTML> Tue, 03 Jul 2012 17:22:57 GMT https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332022#M1171951 swuehl 2012-07-03T17:22:57Z Re: Number repeated https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332023#M1171952 <HTML><HEAD></HEAD><BODY><P>Yes</P><P></P><P>Col1</P><P>10</P><P>10</P><P>10</P><P>10</P><P>3</P><P>2</P><P>2</P><P>4</P><P>4</P><P>5</P><P>5</P><P></P><P>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 ...</P></BODY></HTML> Tue, 03 Jul 2012 17:26:24 GMT https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332023#M1171952 2012-07-03T17:26:24Z Re: Number repeated https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332024#M1171953 <HTML><HEAD></HEAD><BODY><P>You can create a listbox for the field and check 'Show Frequency' in the General tab of the listbox property. </P><P>Also you can set the sort order in the sort tab as frequency descending/ascending depending on your requirement.</P></BODY></HTML> Tue, 03 Jul 2012 17:26:34 GMT https://community.qlik.com/t5/QlikView/Number-repeated/m-p/332024#M1171953 nagaiank 2012-07-03T17:26:34Z