Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Frequency total in list box

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

error loading image

1st attempt of list box and expression

error loading image

Example of how i want it to look

error loading image

Any ideas?

1 Solution

Accepted Solutions
Not applicable
Author

Hi

You can also try

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

Regards

Anders

View solution in original post

2 Replies
Not applicable
Author

Hi

You can mark

Show Frequency in General tab.

Regards

Anders

Not applicable
Author

Hi

You can also try

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

Regards

Anders