topic Re: question about chart colours in Qlik Learning Discussions

question about chart colours

Anonymous — Thu, 05 Mar 2015 14:25:07 GMT

Hi,

Is it possible to change chart colours by clicking on a bar inside a graph?

Please see my question in detail in the file attached.

Thank you in advance,

Larisa Filonova

Re: question about chart colours

morganaaron — Thu, 05 Mar 2015 15:03:53 GMT

Hi Larisa,

Yes - if you ensure that your expressions include the state {1} so that no selections affect the chart, then you can alter the 'background color' expression within your overall expression. If you type in:

if([Your Field] = [Your Field]
, ”
, RGB(200,200,200)
)

RGB() you can replace with whatever colour you want the "non-selected" values to be. The colour they'll show will then be the colour each bar was before - so you can use persistent colours or whichever desired colour you want.

It'll claim the syntax is wrong, but it works!

Re: question about chart colours

Gysbert_Wassenaar — Thu, 05 Mar 2015 15:07:41 GMT

Yes, it's possible. See attached example.

Re: question about chart colours

Anonymous — Thu, 05 Mar 2015 22:20:25 GMT

I'd like to make a selection of several bars (e.g. Lemon and Cherry) by clicking on bars without using a list box.

I tried to select a second bar using Ctrl or Shift button. Neither of them works. How is it possible?

Re: question about chart colours

robert_mika — Thu, 05 Mar 2015 22:37:16 GMT

To select more than one bar

Hold left mouse button and highlight two or more bars

Re: question about chart colours

Anonymous — Thu, 05 Mar 2015 22:58:20 GMT

But in this case you select only those bars that are next to each other.

How can I select the first and the fifth bar for instance?

Re: question about chart colours

robert_mika — Thu, 05 Mar 2015 23:27:55 GMT

Hold CTRL and then click with left mouse button the bars you want to be shown and release CTRL

All bars

Selected:

Re: question about chart colours

Anonymous — Fri, 06 Mar 2015 13:37:41 GMT

I don't quite see what you mean.

Please see the file attached. For instance, I have selected the lemon bar, then I want to select the orange bar. If I click on the bar with the left muse button (plus Ctrl), then a menu appears but the orange bar isn't selected.

How can I select both lemon and orange bar?

Thank you in advance,

Larisa Filonova

Re: question about chart colours

robert_mika — Fri, 06 Mar 2015 13:44:25 GMT

Holding Control Key .

Point to Lemon bar -click with left mouse button

go to Orange bar-click with left mouse button

release control Key