topic Re: Using include- exclude in set analysis in QlikView

Using include- exclude in set analysis

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

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

effinty2112 — Mon, 24 Jul 2017 15:52:08 GMT

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 — Mon, 24 Jul 2017 15:59:22 GMT

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