topic Regarding set analysis coding in QlikView

Regarding set analysis coding

qliksus — Wed, 30 Sep 2009 14:36:59 GMT

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.

Regarding set analysis coding

Wed, 30 Sep 2009 17:47:47 GMT

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

=sum({1-$}Value)

-Arun

Regarding set analysis coding

Wed, 30 Sep 2009 20:42:33 GMT

You need to use the Exclusion Operator.

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

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

Regarding set analysis coding

qliksus — Thu, 01 Oct 2009 18:40:32 GMT

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.

Regarding set analysis coding

johnw — Fri, 02 Oct 2009 00:45:04 GMT

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)

Regarding set analysis coding

qliksus — Mon, 05 Oct 2009 19:16:20 GMT

Thank u John. It's working.