topic Frequency total in list box in QlikView

Frequency total in list box

Wed, 20 Apr 2011 10:28:41 GMT

Hi i wnat my list box to contain in brackets the frequency it occurs. So far i have only managed to contain in brackets the total count of all rather then the specified field count [PROJECT]. Hopefully the images below can illustrate.

Current List box and expression

1st attempt of list box and expression

Example of how i want it to look

Any ideas?

Frequency total in list box

Wed, 20 Apr 2011 10:40:03 GMT

You can mark

Show Frequency in General tab.

Regards

Anders

Frequency total in list box

Wed, 20 Apr 2011 10:45:24 GMT

You can also try

=PROJECT & '- (' & aggr(count(PROJECT),PROJECT) & ')'

Regards

Anders