Too many cells error (Urgent)

[#1]

Hi All,

I have one line chart, where we are displaying sales by product.

Requirement is we want the specific colors to product. So we have taken all the RGB values from 1 excel for each product. we are applying those colors in expression background color like:

RGB(sum({1}R_Product),sum({1}G_Product),sum({1}B_Product)).

But when we r applying this expression it dont displays anythng in chart n one error message comes:

Too many cells.

After removing this background color expression chart is working fine.

Is anybody have an idea when 'Too many cells' error comes and how to solve this issue.

Thanks in Advance..!

[Anonymous]

check this

http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts

hope it helps

Sri1

[Greg_Williams]

I avoid entering calculations/functions as arguments when using colors rgb(calc_condition,calc_condition,calc_condition). Instead, I have used a field value (as listed by srikanthsri1) or if(condition=true,rgb(#,#,#), else...

Is it possible to use multi-colors (as a simple solution), from the colors tab in the chart properties?

Will the ColorMix Wizard help out here?...or not really applicable?

In chart properties, Expression tab, Background Color > File (menu bar) > Colormix Wizard...

-Greg