Color Problem in trend chart

Tue, 12 Mar 2013 07:01:37 GMT

Hi All,

I am using this expression

Sum({$<Timeframe=>}Volume)

to calculate the Product Volume Trend chart. I have Product and Week End Date in the Dimension.

For my master selection, I have Agg Time Frame Filter which is not applicable for this trend chart.

The Numbers and Calulations which I am getting is very fine.

But when I am writing an expression to change the color of trend lines in the Background Color:

Expression:

(Product=1, RGB(51,51,153),

if(Product=2, RGB(150,61,59),

if(Product=3, RGB(121,146,68),

if(Product=4, RGB(119,93,151),

if(Product=5, RGB(243,150,183),

if(Product=6, RGB(254,186,18),

if(Product=7, RGB(121,151,197),

if(Product=8, RGB(96,74,125),

if(Product=9, RGB(0,136,159),

if(Product=10,RGB(210,151,106)

) ) ) ) ) ) ) ) ) )

When Timeframe is not selected the colors are shown in the trend chart but as soon as Timeframe gets selected the color code do not apply. It takes the default color.

Please suggest the solution for this problem.

Thanx

Kumar

Re: Color Problem in trend chart

Tue, 12 Mar 2013 07:20:55 GMT

Hi Gauraw,

Without seeing your data i am unable to use calculations. Please provide me some data or image so that i will do something on this.

topic Re: Color Problem in trend chart in QlikView

Color Problem in trend chart

Re: Color Problem in trend chart