Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Change Color Data Appearance

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?

1 Solution

Accepted Solutions
manojkulkarni
Valued Contributor II

Re: Change Color Data Appearance

you can add background color for each of your expression.

3 Replies
manojkulkarni
Valued Contributor II

Re: Change Color Data Appearance

you can add background color for each of your expression.

buzzy996
Honored Contributor II

Re: Change Color Data Appearance

try tios way for ur each expression,

col.PNG

stigchel
Honored Contributor

Re: Change Color Data Appearance

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

BGColor.png

Community Browser