Show only top 15 Selling Products in Bar Chart, but using a different measure in the chart.
Hi, I want to do the following in a Qlik Sense Bar Chart.
I want to display the top 15 products in terms of sales, but the actual measure used in the Bar Chart will be Growth Rate. So basically is to display the growth rate of the top 15 selling products.
The thing is if I limit the number of values of Product dimension to 15 in the chart setting, it will filter them based on Growth Rate, which is the actual measure being used in the chart, you can't use a different measure to limit the values unfortunately.
Any advice? Maybe creating a Dynamic dimension that only contains the top 15 Selling Products? This should be flexible based on user selections.
