topic Re: Background color pivot and bar chart in QlikView

Background color pivot and bar chart

Wed, 02 Jul 2014 13:53:43 GMT

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.

Re: Background color pivot and bar chart

Greg_Williams — Wed, 02 Jul 2014 13:57:50 GMT

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.

Re: Background color pivot and bar chart

Wed, 02 Jul 2014 14:38:41 GMT

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

Re: Background color pivot and bar chart

Greg_Williams — Wed, 02 Jul 2014 14:51:53 GMT

Can you share the file for me to look at?

Re: Background color pivot and bar chart

Anonymous — Wed, 02 Jul 2014 16:53:15 GMT

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.

Re: Background color pivot and bar chart

Wed, 10 Dec 2014 15:29:26 GMT

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