Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shivalid
New Contributor III

Dimension Limitation in Qliksense Bar Chart

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?

22 Replies
YoussefBelloum
Esteemed Contributor

Re: Dimension Limitation in Qliksense Bar Chart

Hi,

would you be able to add more details here ? like the expected output via an image for example

shivalid
New Contributor III

Re: Dimension Limitation in Qliksense Bar Chart

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?

Capture.PNG

YoussefBelloum
Esteemed Contributor

Re: Dimension Limitation in Qliksense Bar Chart

you mean, you need to display also France and Oland bars ?

also, can you show us the expression used here ?

shivalid
New Contributor III

Re: Dimension Limitation in Qliksense Bar Chart

Yes, I want to display those as well.

The expression is:

Sum(Quantity)

YoussefBelloum
Esteemed Contributor

Re: Dimension Limitation in Qliksense Bar Chart

on what basis do you limit the display of this dimension?

shivalid
New Contributor III

Re: Dimension Limitation in Qliksense Bar Chart

I have put the limitation to Top 3 in the State dimension.

shivalid
New Contributor III

Re: Dimension Limitation in Qliksense Bar Chart

Please find the reference image.

Capture1.PNG

YoussefBelloum
Esteemed Contributor

Re: Dimension Limitation in Qliksense Bar Chart

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))

erik_wetterberg
Honored Contributor

Re: Dimension Limitation in Qliksense Bar Chart

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

Erik Wetterberg
https://extendingqlik.upper88.com/
Community Browser