Frequency Issue in list box

[#1]

Hi,

I am trying to get Frequency of the list box title box.
I have used the following expression:

='Text (' & Count(distinct [Party]) & '/' & count(distinct all [Party]) & ')'

it is working fine with the Presidents_Frequency.qvw file. Same expression i am using with Frequency Test.qvw file it is not showing the result. One by one i am attaching the files as can not upload file in one go.

Thanks in Advance

[#2]

It is not allowing me to upload the President_Frequency.qvw which is working fine.

[Miguel_Angel_Baeyens]

Hello,

Take into account that field names in QlikView are case sensitive so

='Program(' & Count(distinct [PROGRAM]) & '/' & count(distinct all [PROGRAM]) & ')'

using "PROGRAM" instead of "Program" will work.

Regards.

[d_pranskus]

Hi

The problem is that you did not spell the field names correctly. QlikvIew field names are case sensitive, and if your field is in uppercase (APPLICATION) then you MUST spell it uppercase.

Cheers

Darius

[#5]

Thanks Miguel & Darius Pranskus for the reply.

I got confused with editor message 'Bad field name(s):all'

Expression is working fine now. But i am wondered why editor is showing above message.

Please can anybody explain it.

Thanks in advance.

[#6]

Hi Mansi,

as you see

sum( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ] expression )

the keyword "ALL" is no longer available in QV 9. But it is still supported.

That´s the reason you got the message "bad field name".

Rainer

[#7]

Hi what should be used instead of 'ALL' if its not supported in QV9?

Im trying to make a custom list box which hasthe project name [Project] + Count of projects associated. My following formula works but it give a count of ALL projects. What i want is a count of projects / or frequency of the projects associated.

=[Project] & ' - (' & count(total [Project])&')'

Any help??