sales chart

[mrbqlik2009]

Hi,

I have SQL table with this fields:

ID, CustomerName, ProductTitle, Quantity, Price

I want calculate this parameter in qlikview when i select 1 customer in list box:

1. List of all product that selected customer buy.

2. Quantity of each product that customer buy.

3. Total count of customer that buy for each product

4. Total Quantity of all customer that buy for each product

5. Average quantity of all customer that  buy for each product.

6. average of buying for top 10 customer that buy for each product.

7. Buying rank of customer in all customer for each Product.

Thank you

[isingh30]

Can you share your data or sample application?

Thanks.

[Anil_Babu_Samineni]

Perhaps this?

1. Concat(DISTINCT [customer buy], ',')

2. Sum({<[customer buy] = P([customer buy])>} Quantity)

3. Count(TOTAL <Product> [customer buy])

4. Sum(TOTAL <[customer buy]> Quantity)

5. Avg(TOTAL <[customer buy]> Quantity)

6. Avg({<Product={"=Rank(Sum(Quantity))<=10"}>} TOTAL <[customer buy]> Quantity)

7. Not sure, I followed you

[shiveshsingh]

Please share some data to work upon

[mrbqlik2009]

This is sample data i create inline.

My problem is calculate expressions i put in chart.