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: 
Christiann
Partner - Contributor III
Partner - Contributor III

Function GetPossibleCount( . . . ) in an Alternate State

Hello,

for a calculation condition of a chart I'd like to use the amount of possible values from a field in an alternate state.

The function: GetPossibleCount( . . . )  don't know set analysis for something like:

GetPossibleCount( {$<MyField=MyOtherState::MyField>} AnotherField )

How can I do this?

Best regards

Christian

1 Solution

Accepted Solutions
Christiann
Partner - Contributor III
Partner - Contributor III
Author

I need the result for a calculation condition but I find a solution:

not( isnull( only( {MyAlternateState} MyField ) ) )

Thanks for your answer and best regards

View solution in original post

2 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

Maybe you can try with the standard Count function, but applying your alternate state:

Count({MyOtherState} Distinct AnotherField)

JG

Christiann
Partner - Contributor III
Partner - Contributor III
Author

I need the result for a calculation condition but I find a solution:

not( isnull( only( {MyAlternateState} MyField ) ) )

Thanks for your answer and best regards