Trouble with ColorMix1() on Bar Chart Colors

Tue, 16 Jun 2015 23:13:24 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?

topic Trouble with ColorMix1() on Bar Chart Colors in QlikView

Trouble with ColorMix1() on Bar Chart Colors