How to show the frequency in the list box's title text

[#1]

Hi

How to show the frequency in the list box's title text as shown in the below list box.

Thanks and Regards,

Rikab

[#2]

Hi All,

I got it done like this. Added the expression for those users who is looking for the same.

='Item ('& count(itemname) & '/'& count(ALL itemname) & ')'<pre>
Thanks and Regards,
Rikab
 </body>

[wizardo]

only one problem,

im using version 9

the count() function dont accept ALL key word in qv9

i thought of using GetposibleCound + getExcludedCount but

the "getExcludedCount" function only returns the exluded count if the values ware excluded by a selection on another field.

for example, if you have GetExcludedCount(NAME) and you have a selection in another field (COUNTRY) which excludes 6 of the NAMEs then you will have the function return 6.

but if
you have a selection in NAME whice excludes 6 values out of 10 then the function "GetExludedCount(NAME)" reutrn 0

the solution i found was to use the function :FieldValueCount( 'myField')

like that

'Item ('& count(itemname) & '/'& fieldvaluecount( 'itemname') & ')'

Mansyno

[#4]

Hi Mansyno and All,

When i used the above expression said by me to calculate the frequency i am getting wrong count. Don't know the reason why! But it is happening!

Note: Mansyno, when i used your expression i am failed again.

Thanks and Regards,

Rikab

[wizardo]

can you please send a sample QVW

i tried your expression on 8.5 and my expression on both 8.5 and 9 and it works

Mansyno

[#6]

To open the document use userid:0010012021, password:c2info99

The problem is that it shows the same count value for both the manufacturer and the items. Actually the manufacturer should me lesser.

Any way look into it and let me know where we are going wrong.

Thanks and Regards,

Rikab

[wizardo]

you forgot to attach the document

Mansyno

[#8]

Yes I forgot! Now i have attached it. Please check it!

[wizardo]

i opened your file

i think it is a different file then the one you ware mentioning cause i couldn't find the same fields

but i used it anyway

iv added a sheet named wizardo with the formula on two different list boxes

it seems like it is working

or maybe i didn't understand your original meaning

try it

Mansyno

[#10]

In QV9, you can use "{1} TOTAL" instead of "ALL"

Alex