Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How do I dynamically show all of the dimensions that represent 80% of the value?

We want to show all of the brokers for whatever dimensions are selected that comprise 80% of the total value of the revenue. As the users choose a selection like Year or Market or Product, it would dynamically render the group of brokers shown based on whoevers revenue comprised 80% of their selections total.

Basically, usually a small number of brokers (maybe 10%) comprise 80% of the Total revenue. Those are the only ones they want to show. If possible, they would also like to make the 80% dynamic so that they can change that to X%.

We are showing the data in a bar chart.



Community Browser