How can I hide the 'Others' label in a Limitation of Fixed Number when its expression value is zero?
As always, I appreciate your invaluable help. We're building a pie chart for a high executive in which I am using the first 3 (two in my example) dimensions with the highest value and an Others label. The thing is sometimes the Others's value is zero, so I want it to hide it in the pie's legend when that happens, but I can't find a way of doing it. And in my opinion, being the visualization for a director, this gives a bad image.
As it is a pie chart, the sum of the values need to be 100%, so I don't see how can I use rank for the solution, but I'm open to ideas.
I add images and the qvf file.
Image 1: The pie chart
The Others label is in the legend, although its value is zero
Image 2: The undesired 'Others' label when the value is zero.The undesirable 'Others' label