topic Frequency Issue in list box in QlikView

Frequency Issue in list box

Wed, 14 Apr 2010 15:28:06 GMT

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

Frequency Issue in list box

Wed, 14 Apr 2010 15:33:20 GMT

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

Frequency Issue in list box

Miguel_Angel_Baeyens — Wed, 14 Apr 2010 16:02:08 GMT

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.

Frequency Issue in list box

d_pranskus — Wed, 14 Apr 2010 16:05:01 GMT

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

Frequency Issue in list box

Thu, 15 Apr 2010 06:36:02 GMT

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.

Frequency Issue in list box

Thu, 15 Apr 2010 07:22:51 GMT

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

Frequency Issue in list box

Tue, 19 Apr 2011 16:43:38 GMT

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??