Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am setting the Dimension limit to 10 in the Bar chart and on clicking the 'Other' I want to display the remaining Dimensional values as well in the same chart only.
Is there any way I can do that in Qliksense?
Hi,
would you be able to add more details here ? like the expected output via an image for example
Please find the sample image.
So, as you can see when I am clicking on the Others it only shows 2 values (China and Italy) in the chart which I think is due to the Limitation I set.
Is it possible to display all those other values also irrespective of the limitation?
you mean, you need to display also France and Oland bars ?
also, can you show us the expression used here ?
Yes, I want to display those as well.
The expression is:
Sum(Quantity)
on what basis do you limit the display of this dimension?
I have put the limitation to Top 3 in the State dimension.
Please find the reference image.
Ok I see, so with that option (top) enabled, you can't reach the exptected output,
Try this:
1. disable that option
2. use this expression:
=if(GetSelectedCount(State)=0, if(rank(Sum(Quantity),4)<=3, Sum(Quantity)), Sum({1}Quantity))
You are right, that's how it works. When you click others, it selects all values except the two top values, so you will see number 3 and 4 with the rest under the Others category.
I'm afraid this is how it works in Qlik Sense, What you could do is add the same dimension as 'Alternate Dimension' without the limitation. That way users can easily switch to the complete set of values.
Erik Wetterberg