Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Greg_Williams
Employee
Employee

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
Author

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


Greg_Williams
Employee
Employee

Can you share the file for me to look at?

Anonymous
Not applicable
Author

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
Author

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