Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist II
Partner - Specialist II

you can add background color for each of your expression.

View solution in original post

3 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

you can add background color for each of your expression.

buzzy996
Master II
Master II

try tios way for ur each expression,

col.PNG

stigchel
Partner - Master
Partner - Master

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

BGColor.png