topic Re: Best way to understand P and E function ? in QlikView

Best way to understand P and E function ?

click_on_qlik — Mon, 04 Dec 2023 15:26:55 GMT

I mean I'm looking for exercises to train myself
easy then hard

Re: Best way to understand P and E function ?

vincent_ardiet_ — Mon, 04 Dec 2023 15:36:18 GMT

Using Set analysis is basically the same as playing with filters on the UI.
P and E are the same as "Select possible" and "Select Excluded".
So, you can test your expression playing with the filters first.
Something I'm also using from time to time, to understand my set analysis behaviour, is to replace something like a sum of values, with a concat(distinct ...) function with the same values, or keys. This is listing what is taking in account and sometimes it helps.

Re: Best way to understand P and E function ?

click_on_qlik — Mon, 04 Dec 2023 15:40:01 GMT

Ok thanks but i am learning with set analysis like this

Sum({1<Customer=(P({1<ProductName={'AAA Running Shoe'}>}))>} LineSalesAmount )

and I need to masterize that ( not UI but set analysis )

Re: Best way to understand P and E function ?

vincent_ardiet_ — Mon, 04 Dec 2023 15:46:38 GMT

Sure, but if you have some difficulties to understand the syntax, using the UI to reproduce the same things could help.
Here you have a syntax error as P needs a parameter. If you want the possible customers having bought the AAA Running shoe (regardless of any current selections), you need to write:
Customer=P({1<ProductName={'AAA Running Shoe'}>} Customer)

Re: Best way to understand P and E function ?

click_on_qlik — Mon, 04 Dec 2023 16:18:36 GMT

Merci Vincent ! ( I assume you understand 😁 )

Bonne soirée

Re: Best way to understand P and E function ?

rwunderlich — Mon, 04 Dec 2023 17:19:56 GMT

If you want to practice and sharpen your set analysis skills an excellent tool is https://qata.io/

-Rob

Re: Best way to understand P and E function ?

click_on_qlik — Tue, 05 Dec 2023 10:32:39 GMT

I look at this as soon as I finish my current tasks