I am working on a bar chart in QlikView where the stacks on a bar are too many. Is it possible to show in the legend only top 10 where as show all the stacks in the chart?
As you can find in the attached document, the chart should remain as it is like -
Where as the legends should only show the "Type" which has top 10 values only (6,12,16,1,9,20,23,3,17,5) instead of showing all values of "Type"
Is this possible in QlikView? if yes, how?
Thank you very much.
Solved! Go to Solution.
Use below two calculated dimensions
Tick Suppress When Value is Null for BOTH of them
I tried your suggestion and this is what I get -
The legend is shown as expected, however I want the chart to show all the types and not only the top 10 types.
Is this possible?
The solution I gave was based on your sample data and output you suggested.
Provide the final output you are looking for so that I can work accordingly.
Create a bar chart
TIck Suppress When Value is Null for the 2nd Dimension
Thank you for the try.
This is what I get now-
If you see in the below snapshot, the first chart includes all the types whereas the 2nd chart represents only the top 10 types. And in my previous comments I had mentioned that the chart should remain as it is i.e it should include all the types as in the first chart but should show in the legend only top 10 as in 2nd chart. Implementing your solution is close to what I'm looking for. Is it possible to show all the types in the chart but show only top 10 in legend?
Please let me know incase you need more information.