Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Background color pivot and bar chart

Hi,

I have a chart with a expression that has a calculated background color.

Now I want different calculations for the color depending on chart type, especially the pivot chart which doesn’t work that grate, se the pictures below.

Is there a way to do this? I haven’t found any function that detects chart type.

Bar.PNG.png

pivot.PNG.png

5 Replies
Employee
Employee

Re: Background color pivot and bar chart

1 -  User Preferences > Design tab > check Always Show Design Menu Items > OK

2 -  Right click on what you want to change on the Pivot > Format Custom Cells (context menu) > Background color > Calculated color expression.

Not applicable

Re: Background color pivot and bar chart

The background color from the expression always overrides it.

In the expression "Alternativ" I have the color calculated to Blue().

In Pivot > Format Custom Cells (context menu) > Background color > Calculated color expression to White().


Employee
Employee

Re: Background color pivot and bar chart

Can you share the file for me to look at?

jsaradhi
Valued Contributor

Re: Background color pivot and bar chart

i have had this issue before...two options that i know of:

1. use colors that work in both the charts if you use fast change

2. do not use fast change and a) use a container or b) a small icon toggle to switch between bar and pivot charts using conditional show.

Not applicable

Re: Background color pivot and bar chart

@jsaradhi suggestion has worked well. But it would be better if it could be done with fast change.

Community Browser