Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share your data or sample application?
Thanks.
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
Please share some data to work upon
This is sample data i create inline.
My problem is calculate expressions i put in chart.