topic Re: listbox with count in QlikView

listbox with count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: listbox with count

jwjackso — Sat, 17 Feb 2018 21:03:42 GMT

Change the List box caption to this:

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

Re: listbox with count

shiveshsingh — Sun, 18 Feb 2018 01:56:17 GMT

Put this in caption of listbox

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

Re: listbox with count

vishsaggi — Sun, 18 Feb 2018 03:35:24 GMT

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.

Re: listbox with count

Chanty4u — Sun, 18 Feb 2018 15:17:41 GMT

Try this

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

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