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

Prob in P() and E()

nikhilgarg — Thu, 08 Oct 2015 09:45:21 GMT

Hey,

I am trying to implement the P() and E() in sample application but couldn't do so.

In P() expressions, it seems they are not giving the expected results.

Can anyone help me in this?

Thanks

Re: Prob in P() and E()

jonathandienst — Thu, 08 Oct 2015 09:51:49 GMT

What are you trying to do?

What results do you get? And what do you expect?

Re: Prob in P() and E()

rubenmarin — Thu, 08 Oct 2015 09:54:32 GMT

Hi Nikhil, I see it right, in example:

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

It's translated as: Summarize the sales of the customers who has buy 'Shoe'. Thats all the sales of those customers, not only the 'Shoe' Sales.

Shoe was sold to Cutomer1, customer2 and [blank] customer, so it's the same as:

Sum({<Customer={'','Customer1','Customer2'}>}Sales) //Wich result is 1800

Sales Customer '': 1500

Sales Customer 'Customer1': 100

Sales Customer 'Customer2': 200

Re: Prob in P() and E()

hic — Thu, 08 Oct 2015 09:56:10 GMT

What in the result is unexpected? If I select 'Shoe', I get the following result:

and this corresponds in my mind quite well with what the P() function returns: You have numbers for the correct suppliers (blank, 3, 4 and 5) but 0 for the excluded ones (1, 2 and 6).

HIC

Re: Prob in P() and E()

nikhilgarg — Thu, 08 Oct 2015 10:04:02 GMT

Hey,

But as per my understanding,

P({<Product = {'Shoe'}>}Customer)

will give the sum of sales for Customer only and not for Suppplier.

Please correct me if i am wrong.

Thanks

Re: Prob in P() and E()

nikhilgarg — Thu, 08 Oct 2015 10:07:58 GMT

Hey,

But as per my understanding,

P({<Product = {'Shoe'}>}Customer)

will give the sum of sales for Customer only and not for Suppplier.

also if you see in 2nd a nd 3rd expression, i want sum of sales but i am getting sum for other products as well

Please correct me if i am wrong.

Thanks

Re: Prob in P() and E()

nikhilgarg — Thu, 08 Oct 2015 10:09:14 GMT

Hey,

But as per my understanding,

P({<Product = {'Shoe'}>}Customer)

will give the sum of sales for Customer only and not for Suppplier.

also if you see in 2nd a nd 3rd expression, i want sum of sales but i am getting sum for other products as well

Please correct me if i am wrong.

Thanks

Re: Prob in P() and E()

hic — Thu, 08 Oct 2015 10:10:55 GMT

No, it has nothing to do with the sum of sales. The P() returns the Customers that are associated with 'Shoe'. That's all.

And when you use the above function the way you do, you will get sum of sales for customers that are associated with 'Shoe'. All sales, independent of product and supplier. The only filter is on customers.

HIC

Re: Prob in P() and E()

hic — Thu, 08 Oct 2015 10:12:50 GMT

If you want sum of sales only for 'Shoe', you should use

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

and if you, in addition, want to exclude records where the customer is NULL, you should use

Sum({<Product = {'Shoe'}, Customer={"*"}>}Sales)

HIC

Re: Prob in P() and E()

rubenmarin — Thu, 08 Oct 2015 10:14:30 GMT

P({<Product = {'Shoe'}>}Customer) returns the customers who has relation with product Shoe, if you want only Shoe sales you can add that condition to set analysis:

Sum({<Customer = P({<Product = {'Shoe'}>}Customer), Product = {'Shoe'}>}Sales)

Wich doesn't makes more sense as you can directly ask for Product = {'Shoe'}.

It can be usefull in something like:

Sum({<Customer = P({<Product = {'Shoe'}>}Customer), Product = {'Socks'}>}Sales)

It returns the sales of Socks for the customers who has a relation with Shoe