topic Re: List Box - Displaying both frequency and percentage in QlikView

List Box - Displaying both frequency and percentage

Anonymous — Mon, 08 Jun 2015 15:53:59 GMT

Hi,

I need to display both the count (frequency) and the percentage for the field in a list box object. I know that in properties you select 'show frequency' to show the count and 'In Percent' to show the count in a percentage format. I need to display both for the field for example:

Type:

A 20 (20%)

B 50 (50%)

C 30 (30%)

Any suggestions would be greatly appreciated.

Thanks...

Re: List Box - Displaying both frequency and percentage

sunny_talwar — Mon, 08 Jun 2015 16:04:44 GMT

You can use the expression tab within the list box properties tab:

and write a expression like this:

=Count(Type) & ' (' & Num(Count(Type)/Count(TOTAL Type), '#.0%') & ')'

HTH

Best,

Sunny

Re: List Box - Displaying both frequency and percentage

sunny_talwar — Mon, 08 Jun 2015 16:06:37 GMT

Or use this expression if you don't want the count and % to change based on a selection of type:

=Count({<Type = >}Type) & ' (' & Num(Count({<Type = >}Type)/Count({<Type = >}TOTAL Type), '#.0%') & ')'

HTH

Best,

Sunny

Re: List Box - Displaying both frequency and percentage

buzzy996 — Mon, 08 Jun 2015 16:16:20 GMT

see tis,

Re: List Box - Displaying both frequency and percentage

Anonymous — Mon, 08 Jun 2015 16:19:04 GMT

Thank you Sunindia..That worked...

Re: List Box - Displaying both frequency and percentage

sunny_talwar — Mon, 08 Jun 2015 16:21:50 GMT

Awesome

I am glad it worked

Re: List Box - Displaying both frequency and percentage

b_garside — Mon, 08 Jun 2015 16:25:41 GMT

Mark it as Answered....