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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ignore dimension selections for GetPossibleCount()

Hi

Is it possible to ignore the selections on a dimension for GetPossibleCount()  ?

GetPossibleCount() is not a aggregation function so simple Set Analysis is not valid.  If it was valid I would use something like the below

GetPossibleCount ( { <[Dim1]=>}   [Dim2] ) )


Any suggestion for something that is valid ?

Best Regards,     Bill Markham

Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

May be like:

Count ( { <[Dim1]=>}  Distinct  [Dim2] )

View solution in original post

2 Replies
tresB
Champion III
Champion III

May be like:

Count ( { <[Dim1]=>}  Distinct  [Dim2] )

Anonymous
Not applicable
Author

Many thanks, that works perfectly.