Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use calculated Dimension in one chart to drive results in another chart

I have a chart where I calculate the Top 10 Customers by revenue or profit. In my next chart I need to see the quantity of units sold by product for those Top 10 Customers. How do I do this when Customer is not a dimension in the second chart?

1 Reply
Gysbert_Wassenaar

Try something like sum({<Customer={"=rank(sum(Revenue))<=10"}>} UnitsSold). Change the bold names to whatever your field names are called.


talk is cheap, supply exceeds demand