topic Chart Properties in QlikView

Chart Properties

anthony_kinsell — Fri, 06 Mar 2015 17:09:07 GMT

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

Re: Chart Properties

Anonymous — Fri, 06 Mar 2015 17:13:29 GMT

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.

Re: Chart Properties

JonnyPoole — Fri, 06 Mar 2015 17:43:10 GMT

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

Re: Chart Properties

anthony_kinsell — Mon, 09 Mar 2015 09:22:23 GMT

Michael,

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

Re: Chart Properties

anthony_kinsell — Mon, 09 Mar 2015 09:22:56 GMT

Jonathan,

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

Re: Chart Properties

Anonymous — Mon, 09 Mar 2015 16:55:40 GMT

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