Trouble with ColorMix1() in Bar Chart colors

Tue, 16 Jun 2015 21:42:27 GMT

I'm trying to use a bar chart to show how blog posts per category were published, and what the relative views per post value is. From the Colormix Wizard and some tutorials I have the following expression set up.

ColorMix1 (

(Sum (#pageviews)/Count ({$<_published = {1}>} DISTINCT post_title))

/(RangeMax (top(total Sum (#pageviews)/Count ({$<_published = {1}>} DISTINCT post_title),1,NoOfRows(total))))

, Red(), Green())

I've used this on both the text color and the bar color. It is working perfect for the text color, but in the bar color a 1 is returned for all rows, making everything solid green. Any suggestions?

Re: Trouble with ColorMix1() in Bar Chart colors

stigchel — Wed, 17 Jun 2015 15:14:06 GMT

For the bar colors did you do this in the color tab of the properties or in the background color option of the expression?. It should be the last, calculated colors in the color tab are not evaluated over the dimension(s).

topic Trouble with ColorMix1() in Bar Chart colors in QlikView

Trouble with ColorMix1() in Bar Chart colors

Re: Trouble with ColorMix1() in Bar Chart colors