Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor

listbox with count

Hi All,

I want to display the total count of each list box .

below image is attached the same way i want to display..i am unable to find out the option

can some one help me n this? am very new to qlik.



4 Replies
Valued Contributor

Re: listbox with count

Change the List box caption to this:

='Branch '&If(GetSelectedCount(Branch) = 0,Count({$<Branch=>}Branch),GetSelectedCount(Branch))&'/'&Count({$<Branch=>}Branch)

Honored Contributor

Re: listbox with count

Put this in caption of listbox

='Name' &'-' & count(Name)

Esteemed Contributor III

Re: listbox with count

May be try this in your listbox.

= 'Branch' & '(' & Count(DISTINCT Branch) & ')'

Listbox displays distinct data so to know the count of distinct data use DISTINCT in the Count or if you want the frequency of listbox i.,e non distinct count just use count(branch).

To know the frequency or occurrence of data in listbox go to listbox properties General tab and Check Show Frequency.

Esteemed Contributor III

Re: listbox with count

Try this

='Branch('&Count(DISTINCT Branch) &'/'

&Count(DISTINCT {1} Branch)&')'