Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
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

Not applicable

Frequency total in list box

Hi

You can also try

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

Regards

Anders

View solution in original post