Alternate States and Set Analysis

[tinkerz1]

Hi,

I am trying to use set analysis and alternate states to use the current selection and add "* All" to the set and in an alternate state.

But I cant get this formula to work, in another sheet withouth set analysis a similar formula worked, this formula is below

=sum(distinct {$<{Stats1}[Issue Owned by]=[Issue Owned by]+{"* All"}>} [Data M])

I cant see where I am going wrong, the below formula works but not with any alternate state set up.

sum(distinct {$<Company = Company + {"*All"}>}DATA1)

What is the difference I am missing?

[jonathandienst · Accepted solution]

I am not sure if i have understood you correctly. Assuming Stats1 is the alternate state, perhaps this:

=Sum({[Stats1]<[Issue Owned by] += {'* All'}>} distinct [Data M])

[sunny_talwar]

jonathan‌ what exactly is * All? is this a generic filter available within QlikView?

[jonathandienst]

sunindia

No, just a wildcard filter for something, followed by <space> and "All"