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: 
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
tresB
Champion III
Champion III

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

Count({State} Distinct Field)

View solution in original post

2 Replies
tresB
Champion III
Champion III

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!