Persistent Colours (Bar/Line Chart)

[#1]

G'day Community;

I'll do this in two posts since I can't upload two files.. zzz...

Firstly the screenshot attached to this post is what we 'want' in terms of persistent colours. It carries to 8 other graphs on the same sheet. Now we have added an expression to mark a 'baseline' value against the current graph. We are just using a 'Symbol' yet by doing this it changes the colour scheme to all bars being the primary colour (Blue in this case).

The screenshot of what results is posted next.

My question here is can we have the 'Symbols' as part of the Bar/Line chart and still have multi coloured graphs that are persistent.

[#2]

...

[gajapathy74]

Hi,

I hope the settings shown in the attachment will helpful for you.

Regards,

[#4]

Thank you for the prompt response. However I do not think I was clear enough.

I am using TWO expressions. So as you can see in Multi2.png it removes the Multi Colours and changes everything to Blue and then the second expression is marked by the Red circles. What I am trying to accomplish is to retain the Multi Colour property of the Chart whilst still having the second expression marked by a symbol.

[johnw · Accepted solution]

I don't think you can do what you want to do on the colors tab. Basically, when you have more than one expression, QlikView uses the colors to distinguish between your expressions instead of between your dimension values.

But you CAN do it by using an expression for the background color for your bar expression. Something like this:

pick(match("Bus Grp",'AA','AFAP',...),blue(),red(),...)

[#6]

Success!!! Thank you John - It took a bit of work because of some dirty data (Identified using the Trim function... silly typo somewhere...)

Have fixed one headache, a few more to go.

[#7]

Excellent solution !!!! Thanks alot . This really helps in lot of way for me ...

[#8]

John,

I have downloaded the QVW but could not see where are we using the expression to change the color. Please help.

Thanks,

Kashif

[johnw]

Chart Properties -> Expressions -> click on the + next to sum(Sales) -> Background Color