Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
Highlighted
Not applicable

Frequency total in list box

Hi

You can also try

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

Regards

Anders

View solution in original post

2 Replies
Highlighted
Not applicable

Frequency total in list box

Hi

You can mark

Show Frequency in General tab.

Regards

Anders

Highlighted
Not applicable

Frequency total in list box

Hi

You can also try

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

Regards

Anders

View solution in original post