topic Re: P() and E() in QlikView

P() and E()

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

Hi Expert

I want to create a report that said me if one DOCUMENT buy other product in the last 12 months, for example in this case the report have to return only 12345 a 10/2/2016 because in this actual month(08 august) the same document but other product in the last 12 months(10/02/2016 mont=february)

Document	Product	Date
12345	a	10/2/2016
12345	b	10/8/2016
455	a	10/8/2016
887	c	10/2/2016

I have to use P() and E() FUNCTIONS?

somebody have an example to applicate to this case?

Thanks a lot

ATTACHED THIS SAME EXCEL

Re: P() and E()

pablolabbe — Sat, 13 Aug 2016 00:02:03 GMT

Hi Fernando,

Can you post an example of the final result that you need ?

Pablo

Re: P() and E()

pablolabbe — Sat, 13 Aug 2016 00:09:40 GMT

A short explanation about each function

P() let you define an element set based on possible values for a field implied by selections defined inside the parenthesis.

Example:

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

E() let you define an element set based on excluded values of a field implied by selections defined inside the parenthesis.

Example:

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.

Re: P() and E()

fkeuroglian — Sat, 13 Aug 2016 00:16:32 GMT

Pablo, this will be the result

12345 a 10/2/2016

because at this month(august) buy another product(b) and as the line show, he bought some other product(a) in the last 12 months

thanks