Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are working on a Sales Application where the transaction table has the following information:
Date, Item, Customer, Qty, Sales Amount
We are tracking sales on customer by customer basis.
Let say if we select a customer A, and he is buying Item X, Y, Z. The requirement is to see the sales of all those customers buying the items X, Y, Z.
How I can achieve this?
sum({<Customer=, Item=P(Item)>}Qty)
Will show customers buying the same items as the selected customer, but the sum will be limited to the items associated with selected customer.
If you want to sum all products for the customers associated with the items, then try something like:
sum({<Customer=P({<Item=P(Item), Customer=>} Customer)>}Qty)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
sum({<Customer=, Item=P(Item)>}Qty)
Will show customers buying the same items as the selected customer, but the sum will be limited to the items associated with selected customer.
If you want to sum all products for the customers associated with the items, then try something like:
sum({<Customer=P({<Item=P(Item), Customer=>} Customer)>}Qty)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com