Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
|
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!!
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?