Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aytacbas
Contributor III
Contributor III

(selected/total) in caption

Hi;

I want to see how many selected from total

for example  I have 51 product but I selected only 2

product quantity = (2/51)

Thanks

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

I suggest

= count( distinct ProductField) & ' /. ' &  count ( {1} distinct ProductField)

The {1} will show the grand total no matter what selections a user made.  Also i suggest count so that a user will know what the 'possible' products there are in their current selections , not just the products they directly selected.

View solution in original post

6 Replies
Anonymous
Not applicable

If you want to show it on a text object, you can use something like this expression:

='Products Selected: ' & GetSelectedCount(ProductField) & '/' & count({<ProductField=>}DISTINCT ProductField)

Hope it helps.

Gabriel

Edited:

You can also use this same expression in the caption of your list Box.

aytacbas
Contributor III
Contributor III
Author

Thanks but it doesn't work correctly,

when ı select 2 item it shows (0/2) not (2/51)

JonnyPoole
Employee
Employee

I suggest

= count( distinct ProductField) & ' /. ' &  count ( {1} distinct ProductField)

The {1} will show the grand total no matter what selections a user made.  Also i suggest count so that a user will know what the 'possible' products there are in their current selections , not just the products they directly selected.

Anonymous
Not applicable

Take a look on the attached file.

Regards,

Gabriel

aytacbas
Contributor III
Contributor III
Author

ıt worked. I complete succesfully

THANKS

JonnyPoole
Employee
Employee

Super. Can you close the thread with helpful/correct answers?