I am working on a requirement where I need to show the data in a combo chart in Qlik Sense. Below is the requirement,
1. Create a chart with Bar and Line. The x-axis should be MonthYear.
2. The Bar should show the Volume and Line should show the Market share of products.
3. The products of bar are static whereas Line should show top 5 products and remaining products should be labelled as "Total Others".
So in total 6 lines where the 5 lines will show the data of top 5 products and 6th line will show data of the remaining products.
I have implemented the above request using a Combo chart with MonthYear in x-axis and in measure the calculation of each product.
Now what happens is that if i do selection for example, a country then that country has only top 2 competitors and in this case what happens is that, legend of 3rd, 4th & 5th products are still visible but without data. Now I need to hide those legends. Attached a sample qs file.
Please share your ideas or workaround to achieve this requirement.
Thanks in advance.