Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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