Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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])
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])
jonathan what exactly is * All? is this a generic filter available within QlikView?
No, just a wildcard filter for something, followed by <space> and "All"