Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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.
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().
Can you share the file for me to look at?
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.
@jsaradhi suggestion has worked well. But it would be better if it could be done with fast change.