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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
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?