Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

List box Items display count

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

The expression was for the caption.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

13 Replies
trdandamudi
Master II
Master II

Please see the attached and hope this helps:

shilpan
Partner Ambassador
Partner Ambassador

See attached

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Please send code,

I am  using personal edition ,,,

Thanks for reply

shilpan
Partner Ambassador
Partner Ambassador

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

jonathandienst
Partner - Champion III
Partner - Champion III

Like this:


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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Hi,

It will shown like this..Capture.PNG

ahmar811
Creator III
Creator III

Hi,

put Jonathan expression in Caption tab please find below screenshot.

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

Regards

Ahmar

jonathandienst
Partner - Champion III
Partner - Champion III

The expression was for the caption.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein