Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
anthony_kinsell
Creator
Creator

Chart Properties

Hi,

We use a chart to do some analysis on creditors:

We then sometimes apply filters that will change the numbers, my query is as follows:

Is it possible to format the chart so that 0-7 will always be green 8-14 will always be yellow etc, rather than get a result like below:

The normal chart properties won't do this as 15-28 won't always be the 3rd 'group'.

Thanks

Anthony

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

on the color tab you may get a quick fix by checking 'persistent colors'

View solution in original post

5 Replies
Anonymous
Not applicable

It is possible.  How - depends on how the chart is built.  If each bar is a separate expression - use attribute expression for background color in each.

JonnyPoole
Former Employee
Former Employee

on the color tab you may get a quick fix by checking 'persistent colors'

anthony_kinsell
Creator
Creator
Author

Michael,

They aren't seperate expressions unfortunately - built in the script rather that in the chart.

anthony_kinsell
Creator
Creator
Author

Jonathan,

This worked thanks - although I did have to change the order of my colours which I thought was strange!

Anonymous
Not applicable

If it one expression, you can better control colors with a conditional expression for color on the dimension level.