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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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