topic Re: Chars Legend Color Issue in QlikView

Chars Legend Color Issue

Sat, 04 Apr 2015 10:07:33 GMT

Hi Team,

I got a problem regarding Charts legend color. The scenario is I have a Combo Chart where Stack Bar show the Sales value company wise and line show the Growth%,I use one dimenssion and multiple expression. In expression I am using the Background color option, the chart is showing the Sales value for month wise for different company through stack bar.

For individual company I am using individual expression. Color for every company is different and retrive this RGB() for every company from different table, the main transanction table is conected with the color table through the Cname(Company Name) field.

In normal scenario it's working fine but the problem is when for a specific company for a first month if data is not present the legend symbol showing the black color while the stack bar showing the exact color for next month onwards where data is available for this company.

I can't use Company as a dimenssion because I have to show the growth through different expression and combo chart not supported multiple dimenssion & multiple expression.

In above image BBB showing black in legend symbol but the color of BBB is blue which show in a bar.

For better understanding I am attaching the application and the data file also.

Please help.

Regards

Anup

Re: Chars Legend Color Issue

Anonymous — Sat, 04 Apr 2015 11:13:48 GMT

Hi Anup,

this is because your Legend colors are calculated based on the respective values for first Tdate

I did a lil tweak as this calculation need not to be referenced with Dimension I have added 3 variables and passed them to the color

so at any given time as variable are calculated irrespective of Tdate we will get colors calculated for all our expressions

check out the attached application hope this helps

mark helpful/correct answer

regards,

Bhagirath S

Re: Chars Legend Color Issue

Sat, 04 Apr 2015 15:36:05 GMT

Thanks Bhagirath. It's working fine.

Re: Chars Legend Color Issue

Anonymous — Sat, 04 Apr 2015 16:17:13 GMT

your welcome

Cheers...!!!

Bhagirath