How to exclude a value of a field from set analisys?

[#1]

How to exclude a value of a field from set analisys?

Will add fovea F1 <F2 C field.
I use the set analisisys.
What do you think?

F1	F2
a	1
f	1
g	1
d	2
a	3
s	3
a	4
s	4
a	5
s	5
s	6 F1 sum(F2) sum( {$<F1 = {'<c'}>} F2 ) a 13 0 d 2 0 f 1 0 g 1 0 s 22 0

[marcel_olmo]

Hey Andrea, if you're looking for a substraction of two tables, I recommend you the following post :

http://community.qlik.com/forums/t/35374.aspx

But If you want a set analysis of excluded values, you need to do this :

sum( {$< F1 -= {'c' }> } F2)

Hope that helps!!

[#3]

hanks Marcelo work.
selected a value of F1, I would add all the values of a field showing F1 F2 <F1 selected.
I can write a set analisys in your opinion?