how to enable 'show frequency' in listbox

[#1]

when i create list box 'show frequency' option is disabled .how to enable 'show frequency' in listbox. ????

[JonnyPoole · Accepted solution]

The help says: 

Show Frequency

Toggles the status for whether the frequency of a field value is shown or not. By frequency is meant the number of selectable combinations in which the value occurs. This option is not available for calculated fields. ... are you using a calcualted field ?

[#3]

thanks for that:

No it is not calculated field it is just number like fileld name is  AGENCYNUMBER(1,2,3,4,1,5,6,3,2,12,34,54,46,35,2,12..........................) repeated values will come under field .

but in list box 'show frequency' option is disabled how can i enable?

[JonnyPoole]

interesting. can you attach the QVW or the source data as a XLS / CSV ?

[#5]

i can not send data it is restricted.

[JonnyPoole]

ok. the purpose of asking was so that i could understand what the data looks like and what the populated list box looks like. I don't have a firm idea based on the written description.  Anything else you can share (screenshot etc..) will help.

[rwunderlich]

The "Show Frequency" option is disabled for Key fields. Is this a Key field?

-Rob

[jaimeaguilar]

Just adding to what Rob already said, if the field is a key field, a solution is to create in script a duplicate of that field, so you can show frequency from a listbox,

regards

[#9]

yes  that is key field

[Anonymous]

Hi Sanjeev,

I suggest you to mark answer of Rob as correct, as i also found for certain listboxes, showfrequency is not allowed. e.g. key field, input field etc.