Alternate state in Calculation condition section qlik sense

[UserID2626]

Hi,

Is it possible to apply alternate condition in calculation condition, i tried with expression its not working

GetSelectedCount(Only({[A]}Product_ID))=1 //getting error *Nested aggregation not allowed*

GetSelectedCount(aggr(only({[A]}Product_ID),Product_ID))=1 //No error but not working correctly

How to apply alternate state ??

[DavidM]

IF A is name of your alternate state, try this:

GetSelectedCount(Only({<Product_ID=[A]::Product_ID>}Product_ID))=1

[UserID2626]

Thanks for the response DavidM 

But I am getting the same error which mentioned in question 

[DavidM]

Remove only from that formula

[tresesco]

In Getselectedcount() you can directly use alternate state, it was long back (in some qv 11.xx) when it was not allowed. 

So try like:

GetSelectedCount({[A]} Product_ID)=1

[UserID2626 · Accepted solution]

Thank you so much Tresesco 

I  got solution from Your post, but the expression you mentioned was not worked. Below expression is working correctly.

GetSelectedCount([Product_ID],True(),'A')=1

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

So Marking this as a solution.

Thanks Tresesco  &   DavidM