topic Re: How can i count my list box item? in QlikView

How can i count my list box item?

omid5ive — Sun, 14 Oct 2012 06:33:47 GMT

i hva esome list box with some item

i want to know the count of the list box item

For example:

in this list box the count is 7

Re: How can i count my list box item?

Gysbert_Wassenaar — Sun, 14 Oct 2012 07:40:29 GMT

You can display this in a text box. The expression =count(Sport) will show the number of items. If you want to count only unique items you can use =count(distinct Sport). If you need the count of items regardless of what is selected in your listbox you use =count({1} Sport)

Re: How can i count my list box item?

omid5ive — Sun, 14 Oct 2012 07:50:45 GMT

hi Gysbert Wassenaar

it will shoe the count of sport in sport table not in list box

this listbox will show some item of the sport table

i want to know the count of item in this listbox

Re: How can i count my list box item?

Sun, 14 Oct 2012 08:07:34 GMT

Use getpossiblecount(Sport)

Re: How can i count my list box item?

omid5ive — Sun, 14 Oct 2012 08:08:31 GMT

for example in this document i want to know the count of the "test" list box in textbox
how can i do it?

Re: How can i count my list box item?

Gysbert_Wassenaar — Sun, 14 Oct 2012 08:13:23 GMT

In your example you can use =count({1} {<A = {">4"} >} A) to get the value 3 returned.

Re: How can i count my list box item?

omid5ive — Sun, 14 Oct 2012 08:14:24 GMT

thanks Gysbert Wassenaar

Re: How can i count my list box item?

omid5ive — Sun, 14 Oct 2012 09:38:53 GMT

sorry

but it does not depend on list boxit will set some condition on my table and count the field

i want to load some data in my listbox with some condition from table

after that i want to count that list box item and for example if the count of the list box item is 2 shopw some note