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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former 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
Former Employee
Former 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
Former Employee
Former Employee

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