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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.