Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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

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
Community Browser