topic Re: Substract choices from alternate state from original set in App Development

Substract choices from alternate state from original set

Mt3 — Wed, 26 Jan 2022 11:56:31 GMT

Hi,

Has anybody tried to substract choices from alternate state from data set original set?

Lets assume we have a filter field called Value, on which we have assigned AlternateState1. I would like to show values remaining in the value set after user choses Values assigned to AlternateState1:

count(Value)-count({[AlternateState1]}Value)

However, when I visualize results in a new table (alternate state:default) , amount is not being substracted at all.

Would be grateful for any suggestions where to look next, as apparently this alternate state identifier in the set expression is not working properly.

Re: Substract choices from alternate state from original set

anat — Wed, 26 Jan 2022 12:20:24 GMT

count(all Value)-count({[AlternateState1]}Value)

Re: Substract choices from alternate state from original set

Mt3 — Wed, 26 Jan 2022 12:36:09 GMT

Thank you for the response, the result does not change either. I have also tried

COUNT({1 - AlternateState1} [VALUE])

But the new table does not reflect results at all - when I chose a Value in AlternateState1, values in tables remain unchanged. Could it be some issue with Alternate States itself? I have assigned them to filters by Apperance - > State-> AlternateState1.