Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mtol
Contributor
Contributor

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

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)

Qlik Sense Enterprise on Windows 

Labels (1)
2 Replies
Mark_Little
Luminary
Luminary

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

mtol
Contributor
Contributor
Author

Hi Mark,

 

The selector for Department is using the default state.