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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I count the number of values for a particular filter in the current filters box?

Cay I have a dimension called X, i want to count the number of values that were selected for x in the current filters box

4 Replies
swuehl
MVP
MVP

=GetSelectedCount( X )

fred_s
Partner - Creator III
Partner - Creator III

Hi Chris,


To be honest I don't understand your question.
Perhaps something like this?

To count the associated values
=count(X)

To count the unique associated values
=count(DISTINCT X)

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

another option would be putting this in the caption (in case you're using listbox as filter):

FieldName & '(' Count(Distinct FieldName) & '/' & Count(Distinct all FieldName) & ')'

Amit
Contributor III
Contributor III

Great. Just the answer I was looking for 🙂