I'm trying to create a bar chart in Qlik Sense which shows top 5 regions by total spend. I managed to do this very easily. I now want show the top 5 regions by total spend where the region has had a minimum of 50 orders. I tried something like this but it doesn't work
=if(count(order_num)>=50,region_name)
How can I filter the x-axis of my chart so it shows only the regions which had minimum 50 orders?
You have a measure in your chart for calculating the total spend. Change the expression of that measure to make it calculate the total spend only for the regions that have more than fifty orders. For example sum(Spend) would become sum( {<region_name={"=count(distinct order_num)>=50"}>} Spend)
You have a measure in your chart for calculating the total spend. Change the expression of that measure to make it calculate the total spend only for the regions that have more than fifty orders. For example sum(Spend) would become sum( {<region_name={"=count(distinct order_num)>=50"}>} Spend)
