topic Re: sales chart in QlikView

sales chart

mrbqlik2009 — Sat, 19 May 2018 09:02:03 GMT

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 — Sat, 19 May 2018 10:01:50 GMT

Can you share your data or sample application?

Thanks.

Anil_Babu_Samineni — Sun, 20 May 2018 05:20:38 GMT

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 — Sun, 20 May 2018 09:19:35 GMT

Please share some data to work upon

mrbqlik2009 — Sun, 20 May 2018 11:25:39 GMT

This is sample data i create inline.

My problem is calculate expressions i put in chart.