Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stijnphilips
New Contributor III

Top 5 bar chart colouring, 'others' is grey

Hi experts,

I am trying to create a bar chart displaying a top 5. The fifth value would cover all other values. We can accomplish this by checking the Others option in the fixed limitation section. However, this value is always grey. Is there any option to change it so that it matches the colouring of the other bars?

Thanks!

Stijn

1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Top 5 bar chart colouring, 'others' is grey

Create your dimension as a master item (master dimension) and there u can define the color of OTHERS:

ps: create ur dimension, then click on it to edit it; that's how u could access to its color

Capture.PNG

I choose red; result:

Capture.PNG

6 Replies
YoussefBelloum
Esteemed Contributor

Re: Top 5 bar chart colouring, 'others' is grey

Hi,

would you be able to share a QVF ?

ruanhaese
Contributor

Re: Top 5 bar chart colouring, 'others' is grey

Hi

Remove the "Show Others" Below the "Limitation" on the Dimension.

Then it will only display the Top 5

The 5th value on yours is that large because it collects the total of all the others.

If you remove the "show others" then it only limits it to the Top 5

(i.e. its currently Top 4 + Others - not Top5)

omarbensalem
Esteemed Contributor

Re: Top 5 bar chart colouring, 'others' is grey

Create your dimension as a master item (master dimension) and there u can define the color of OTHERS:

ps: create ur dimension, then click on it to edit it; that's how u could access to its color

Capture.PNG

I choose red; result:

Capture.PNG

stijnphilips
New Contributor III

Re: Top 5 bar chart colouring, 'others' is grey

Thanks for your response! However, I would like to show the fifth value as being 'Others'

stijnphilips
New Contributor III

Re: Top 5 bar chart colouring, 'others' is grey

Thanks for your response! This does the trick when I make masteritems for the measures.

YoussefBelloum
Esteemed Contributor

Re: Top 5 bar chart colouring, 'others' is grey

Try using rank() function