Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
leni_harishwara
Partner - Contributor III
Partner - Contributor III

Legend issue in Combo chart - Qlik Sense

Hi All,

I am working on a requirement where I need to show the data in a combo chart in Qlik Sense. Below is the requirement,

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.

Regards,

Leni Balakrishnan

0 Replies