Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box selection calculation in Caption

I have a Customers List box.  There are 92 customers.  In the title the display should be "Customers = 92/92".  If I select 3 customers then the display should change to "Customers = 3/92".  Can anybody please let me know how to display?

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Use the expression

=GetSelectedCount(customer) & '/' & Count({1<customer=>}distinct customer)

for the title in the List box Properties Window -> General tab

Capture.PNG.png

View solution in original post

3 Replies
nagaiank
Specialist III
Specialist III

Use the expression

=GetSelectedCount(customer) & '/' & Count({1<customer=>}distinct customer)

for the title in the List box Properties Window -> General tab

Capture.PNG.png

Not applicable
Author

This expression should work too:

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

MarcoWedel

Hi,

another one:

QlikCommunity_Thread_130513_Pic1.JPG.jpg

QlikCommunity_Thread_130513_Pic2.JPG.jpg

hope this helps

regards

Marco