Colors in a bar chart

Anonymous — Mon, 04 Apr 2016 09:57:08 GMT

So I found this wonderful trick (Qlikview Notes: A Color Trick) to change the color of some of the stacked bar charts to be lighter. I faced a similar situation. But I have 3 dimensions in my case: Company, Metric and Year.

The sum(value) of the metric is my expression. I have chosen year as my primary and Company as secondary dimension and the metric is stacked. I get only 2 colors when i use an expression like this:

if(Company=SubField($(vCompany),’,’,1),argb(75,255,255,255) bitand color(FieldIndex(‘Metric’,Metric)) , If(Company=SubField($(vCompany),’,’,2),argb(100,255,255,255) bitand color(FieldIndex(‘Metric’,Metric)),If(Company=SubField($(vCompany),’,’,3),argb(125,255,255,255) bitand color(FieldIndex(‘Metric’,Metric)),

If(Company=SubField($(vCompany),’,’,4),argb(150,255,255,255) bitand color(FieldIndex(‘Metric’,Metric)),If(Company=SubField($(vCompany),’,’,5),argb(175,255,255,255) bitand color(FieldIndex(‘Metric’,Metric)),If(Company=SubField($(vCompany),’,’,6),argb(200,255,255,255) bitand color(FieldIndex(‘Metric’,Metric)),If(Company=SubField($(vCompany),’,’,7),argb(255,255,255,255) bitand color(FieldIndex(‘Metric’,Metric)),color(FieldIndex(‘Metric’,Metric))))))))).

Please help..

Re: Colors in a bar chart

Anonymous — Tue, 05 Apr 2016 07:21:37 GMT

supriya could you please share the sample data and screenshot of your problem?

also try to explain your problem in detail...

Re: Colors in a bar chart

Gysbert_Wassenaar — Tue, 05 Apr 2016 12:15:21 GMT

How many metrics do you have? That's the number of colors you'll see in various shades.

Can you post a small qlikview document that demonstrates the problem?

topic Colors in a bar chart in QlikView

Colors in a bar chart

Re: Colors in a bar chart

Re: Colors in a bar chart