topic Exclusion of default state selection doesn't work in alternate state in App Development

Exclusion of default state selection doesn't work in alternate state

mtol — Thu, 12 Jun 2025 08:30:47 GMT

I'm using two alternate states (Left and Right) to compare two periods. In my expression I want to derive the number of new customers where the previous period is in alternate state Left. The latest period is in alternate state Right. I try to ignore a selection on [Department] in the deault state.

However the outcome of the calculation differs when I make a selection on Department in the default state.

What is wrong with my expression?

Count({Right*$<
%Relation_key = e({Left*$}%Relation_key),
[Department]=
>}
DISTINCT %Polis_key)

Re: Exclusion of default state selection doesn't work in alternate state

Mark_Little — Thu, 12 Jun 2025 13:46:33 GMT

I don't use alternate states very often, but what state is your selector using for Department?

Re: Exclusion of default state selection doesn't work in alternate state

mtol — Mon, 16 Jun 2025 04:52:56 GMT

Hi Mark,

The selector for Department is using the default state.