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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

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

View solution in original post

2 Replies
tresesco
MVP
MVP

May be like:

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

Anonymous
Not applicable
Author

Many thanks, that works perfectly.