Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
omid5ive
Creator II
Creator II

How can i count my list box item?

hi

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

listbox.JPG

1 Solution

Accepted Solutions
Not applicable

Use getpossiblecount(Sport)

View solution in original post

7 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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)


talk is cheap, supply exceeds demand
omid5ive
Creator II
Creator II
Author

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

Not applicable

Use getpossiblecount(Sport)

omid5ive
Creator II
Creator II
Author

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

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
omid5ive
Creator II
Creator II
Author

omid5ive
Creator II
Creator II
Author

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