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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
oknotsen
Master III
Master III

GetPossibleCount() does not support Alternate States?

I get the impression that GetPossibleCount() does not support Alternate States.

https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFun...

GetPossibleCount(SomeField) seems to work, yet GetPossibleCount({DifferentState} SomeField) does not.

So I am wondering if this is a bug or a missing feature?

 

Just for reference, this is why I like to use it:

I have a line chart in which I am comparing two products. The second product is selected in a filter in an Alternate State. I set a calculation condition on the chart to only work if only one product is selected (with GetPossibleCount()) yet it starts complaining when I add the {State} part.

May you live in interesting times!
Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

These field functions don't support this feature. You could alternatively use :

Count({State} Distinct Field)

View solution in original post

2 Replies
tresesco
MVP
MVP

These field functions don't support this feature. You could alternatively use :

Count({State} Distinct Field)

oknotsen
Master III
Master III
Author

So missing feature it is.

Thanks for the alternative solution!

 

May you live in interesting times!