topic Re: List box Items display count in QlikView

List box Items display count

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

Hi All,

I want to display the total count of the 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 on this? I am very new to qlik.

Thanks..

Sunil

Re: List box Items display count

trdandamudi — Mon, 19 Feb 2018 01:06:43 GMT

Please see the attached and hope this helps:

Re: List box Items display count

shilpan — Mon, 19 Feb 2018 03:51:16 GMT

See attached

Re: List box Items display count

Anonymous — Mon, 19 Feb 2018 04:15:35 GMT

Thanks for the response,

I am using personal edition , i cant able to open qvw file

Please send screenchart/ code..

I am new qlikview.

thanks

Sunil.

Re: List box Items display count

Anonymous — Mon, 19 Feb 2018 04:16:58 GMT

Please send code,

I am using personal edition ,,,

Thanks for reply

Re: List box Items display count

shilpan — Mon, 19 Feb 2018 04:41:12 GMT

=if(isnull(GetFieldSelections(Branch)), 'Branch ' & Count(Branch) &'/' &Count(Branch),'Branch ' &GetSelectedCount(Branch) &'/' &Count({1} Branch))

Re: List box Items display count

jonathandienst — Mon, 19 Feb 2018 04:41:23 GMT

Like this:

=Count(Distinct Branch) & '/' & Count({1} Distinct Branch

Re: List box Items display count

Anonymous — Mon, 19 Feb 2018 05:14:47 GMT

Hi,

It will shown like this..

Re: List box Items display count

ahmar811 — Mon, 19 Feb 2018 05:29:21 GMT

Hi,

put Jonathan expression in Caption tab please find below screenshot.

=Count(Distinct Branch) & '/' & Count({1} Distinct Branch

Regards

Ahmar

Re: List box Items display count

jonathandienst — Mon, 19 Feb 2018 05:30:23 GMT

The expression was for the caption.

Re: List box Items display count

sumanta12 — Mon, 19 Feb 2018 05:32:07 GMT

Hi Sai,

Please write the expression in Title section of List Box.

='Branch '&Count(Distinct Branch) & '/' & Count({1} Distinct Branch)

Re: List box Items display count

Anonymous — Mon, 19 Feb 2018 06:09:19 GMT

Thanks ..its working...

Re: List box Items display count

Anonymous — Mon, 19 Feb 2018 06:09:48 GMT

Thanks Jonathan....

Re: List box Items display count

Anonymous — Tue, 20 Feb 2018 04:38:51 GMT

Thanks Ahmar..