topic Alternate States and Set Analysis in QlikView

Alternate States and Set Analysis

tinkerz1 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 07 Mar 2016 14:10:38 GMT

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 — Mon, 07 Mar 2016 14:21:32 GMT

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

jonathandienst — Tue, 08 Mar 2016 04:52:19 GMT

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