Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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