topic List box total count in QlikView

List box total count

manisha_uit — Wed, 20 Jul 2011 05:58:01 GMT

Hi,

How to display the total count of the values present in a particular list box?

Thanks

Manisha

List box total count

kaushiknsolanki — Wed, 20 Jul 2011 06:51:56 GMT

Hi,

Do you mean to say if you have 100 values in listbox you want to show 100.

Or do you mean that you have 100 values which are repeated in listbox and you want to know which value is repeated how many times.

Regards,

Kaushik Solanki

List box total count

manisha_uit — Wed, 20 Jul 2011 06:57:03 GMT

Hi,

I mean if i have 100 values in the list box it should show 100 like a statistic count.

Thanks

Manisha

List box total count

kaushiknsolanki — Wed, 20 Jul 2011 07:00:04 GMT

Hi,

Create a textbox.

In text area type

=count(Filedname)

Here field name is the one for which you have created the list box.

Regards,

Kaushik Solanki

List box total count

manisha_uit — Wed, 20 Jul 2011 07:14:08 GMT

Hi,

Thats fine.

But how to get the count on the same list box.

Like on the left side i have field name and the count on the right side.

Thanks

Manisha

List box total count

kaushiknsolanki — Wed, 20 Jul 2011 07:17:40 GMT

Hi,

Ok.

Go to the properties of the listbox -> in expression tab -> add expression -> count(Field)

Regards,

Kaushik Solanki

List box total count

SunilChauhan — Wed, 20 Jul 2011 07:18:25 GMT

in caption of list box u can write expression folloing '=' sign.

thanks

Sunil Chauhan

List box total count

manisha_uit — Wed, 20 Jul 2011 07:36:47 GMT

Hi Kaushik,

Thanks for your reply. But what you suggested gives me the following result.

Instead i want to display something like:

Please look into this.

Thanks

Manisha

List box total count

kaushiknsolanki — Wed, 20 Jul 2011 07:42:08 GMT

Hi,

In properties of the listbox -> General Tab -> In Title Type below statement.

='Grade ' & count(Grade)

Regards,

Kaushik Solanki

Re: List box total count

SunilChauhan — Wed, 20 Jul 2011 07:43:42 GMT

see the attached file

List box total count

manisha_uit — Wed, 20 Jul 2011 07:51:19 GMT

Hi kaushik,

Thanks a lot.

Manisha

Re: List box total count

diwaskarki — Thu, 09 Aug 2018 21:24:15 GMT

Hi Kaushik,

how do I see how many times the data is repeated in the list box?

Re: List box total count

kaushiknsolanki — Fri, 10 Aug 2018 09:53:46 GMT

HI,

Put the listbox with the desired field and check the option under General Tab i.e Show Frequency.

Here is frequency shows the numbers of time the data appeared in table.

Regards,

Kaushik Solanki