topic Change Color Data Appearance in QlikView

Change Color Data Appearance

Wed, 13 May 2015 11:16:19 GMT

I have a chart with amount of orders per month. "count(OrderID)" Dimension "Month"

I also added 5 other expressions with the order amount per month from the previous years

"count({<Year={$(=Year-1)}>} OrderID)" 2014

"count({<Year={$(=Year-2)}>} OrderID)" 2013

"count({<Year={$(=Year-3)}>} OrderID)" 2012

"count({<Year={$(=Year-4)}>} OrderID)" 2011

"count({<Year={$(=Year-5)}>} OrderID)" 2010

The expressions from 2013 until 2010 I gave a conditional show controlled by a dropdown box where the user can select if he wants to look back only 1 year, or 2, 3, 4 or 5 years back.

My problem now is that with this conditional show the "persistent colors" function doesn't work anymore. The colors change every time I add of remove one or more of the expressions.

Anyone has any idea how to solve this?

Re: Change Color Data Appearance

manojkulkarni — Wed, 13 May 2015 11:22:05 GMT

you can add background color for each of your expression.

Re: Change Color Data Appearance

buzzy996 — Wed, 13 May 2015 11:27:27 GMT

try tios way for ur each expression,

Re: Change Color Data Appearance

stigchel — Wed, 13 May 2015 11:29:28 GMT

Expand the expression options by clicking on the + sign in front of the expression and set a color for each