Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.