Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jjking58
Contributor III
Contributor III

Using include- exclude in set analysis

Hi,

I have a two part question.

is it possible to use the following to list excluded customers for the current selection with the exception of year and month

(sum({$<CustomerName= E(CustomerName),fYear=,FMonth=>} PartsAmt) +

sum({$<CustomerName= E(CustomerName),fYear=,FMonth=>} EqupAmt) +

sum({$<CustomerName= E(CustomerName),fYear=,FMonth=>} LaborAmt))

Also can you have more then one (E) in the same expression

Thanks in advance

2 Replies
effinty2112
Master
Master

Hi Jim,

The E() function in not intended for this, more like

Sum({$<Customer = E({<Product = {'Shoe'}>})>}Sales)

gives the value of Sales for customers that have never bought a shoe.

To exclude from the current selection try something like:

sum({1-$}PartsAmt)

if you have only made selections on the field Customer then this might be what you need

Regards

Andrew

jjking58
Contributor III
Contributor III
Author

Andrew thanks for the response, but i want to include the current selections with the exception of year and month.

Using  {1-$}PartsAmt) totally ignores all  current selections. I want to show a table of what was not purchased based on the selection