Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

What is the difference between -= and E() in qlik sense?

What is the difference between -= and E() in qlik sense? Please give me an example or where should I use them? I am confused between these 2.

Labels (3)
1 Reply
Or
MVP
MVP

-= removes certain things from a set, e.g. Field -= Value1 will return a set of all non-Value1 (and non-null) values from Field.

E() means values excluded by a specific subset. You should look up the documentation for this for examples, but one example is:

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )
returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.