Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

sales chart

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

Tags (3)
4 Replies
Highlighted
Specialist
Specialist

Re: sales chart

Can you share your data or sample application?

Thanks.

Highlighted

Re: sales chart

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master
Master

Re: sales chart

Please share some data to work upon

Highlighted
Contributor III
Contributor III

Re: sales chart

This is sample data i create inline.

My problem is calculate expressions i put in chart.