listbox with count

[Anonymous]

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.

Thanks..

Sunil

[jwjackso]

Change the List box caption to this:

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

[shiveshsingh]

Put this in caption of listbox

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

[vishsaggi]

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.

[Chanty4u]

Try this

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

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