Regarding set analysis coding

[qliksus]

Hi,

Can anyone help me to write Not expression in set analysis?? I have dimension 'Name' which contains names of diffrent persons. But i want to calculate the sum of value expect a particular name in set analysis. I tried with sum({$<Name={'<>abc'>}Value). But it is not working. So please tell me how to write.

[#2]

IF 'name' is the the current selection, try this:

=sum({1-$}Value)

-Arun

[#3 · Accepted solution]

You need to use the Exclusion Operator.

Sum({<Name -= {'abc'}>} Value)

Putting the minus before the equals gets you everything but the set defined.

[qliksus]

Thanks NMiller. Your code gives me the correct output. But when i replace minus sign(-) to plus sign(+) then it is giving total amount not the total+add amount.

[johnw]

The + sign here is a set UNION, not a numeric addition. You're dealing with sets, not numbers. So when you union the full set to a sub set, you get the full set. Similarly, the - sign was a set exclusion, not a numeric subtraction. It's just that in that case, you would get the same answer either way you think of it.

sum(set - subset) = sum(set) - sum(subset)
sum(set + subset) = sum(set)
sum(set + subset) =/= sum(set) + sum(subset)

[qliksus]

Thank u John. It's working.