Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

F1F2
a1
f1
g1
d2
a3
s3
a4
s4
a5
s5
s

6

F1sum(F2)sum( {$<F1 = {'<c'}>} F2 )
a130
d20
f10
g10
s22

0

2 Replies
marcel_olmo
Partner Ambassador
Partner Ambassador

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!!

Not applicable
Author

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?