Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
dafnis14
Contributor III

Disable bar charts colors & use background expression instead

Hi,

I have a bar chart with a conditional expression.

For each expression I defined a background color.

But the colors are still retrieved from the Colors tab.

Is there a way to disable the default Colors and use a background color with expression only?

Thanks!

4 Replies
Not applicable

Re: Disable bar charts colors & use background expression instead

Could you share the qwd file to understand the issue please?

manucamon
Valued Contributor III

Re: Disable bar charts colors & use background expression instead

HI Dafnis X,

if you have conditioned color background and your don't set the colours for true and false, QlikView will return the default color for false options.

Could you attach one example of your app to see your expressions please?

Regards!

dafnis14
Contributor III

Re: Disable bar charts colors & use background expression instead

Hi Manuel,

I have used variables for the color.

For example:

vBranchColor    RGB(255,169,0).

But now I realized that I should have defined it

=RGB(255,169,0).

Another words, I have forgotten the equal sign..

Thanks anyway 🙂

manucamon
Valued Contributor III

Re: Disable bar charts colors & use background expression instead

Don't worry, i don't know that you have calculated it with vars.

Regards!!!!