GetPossibleCount() does not support Alternate States?

oknotsen — Sat, 16 Nov 2024 20:53:20 GMT

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/FieldFunctions/getpossiblecount.htm

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.

Re: GetPossibleCount() does not support Alternate States?

tresB — Mon, 13 May 2019 08:06:56 GMT

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

Count({State} Distinct Field)

Re: GetPossibleCount() does not support Alternate States?

oknotsen — Mon, 13 May 2019 08:31:01 GMT

So missing feature it is.

Thanks for the alternative solution!

topic GetPossibleCount() does not support Alternate States? in App Development

GetPossibleCount() does not support Alternate States?

Re: GetPossibleCount() does not support Alternate States?

Re: GetPossibleCount() does not support Alternate States?