Stacked Chart - Custom Coloring

[#1]

Hello,

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. However, what I really want to do is have seperate colors for TYPE (A,B) and then lighten SIZE (S,M). See image below.

Any ideas?

Thanks!

[#2 · Accepted solution]

Hi

if(Name = 'Manish' and Game='Summer', rgb(76,153,0),

if(Name = 'Manish' and Game='Winter',argb(96,76,153,0)bitand Color(FieldIndex('Game',Game)),

if(Name = 'Padma' and Game='Summer', rgb(204,102,0),

if(Name = 'Padma' and Game='Summer', argb(96,204,102,0) bitand Color(FieldIndex('Game',Game))

))))

tyring to figure out how to attach a sample file

Regards

Padma

[#3]

Hi

if(Name = 'Manish' and Game='Summer', rgb(76,153,0),

if(Name = 'Manish' and Game='Winter',argb(96,76,153,0)bitand Color(FieldIndex('Game',Game)),

if(Name = 'Padma' and Game='Summer', rgb(204,102,0),

if(Name = 'Padma' and Game='Summer', argb(96,204,102,0) bitand Color(FieldIndex('Game',Game))

))))

Please find attached sample file

Regards

Padma

[#4]

Hi

This is a long winded code, i am trying is there a better way of doing this

May using variables

Regards

Padma

[#5]

Hi Padma/Jaro,

I have seen the color trick mentioned earlier.

I have a requirement, comparing Actual vs Budget per month. so I created a grouped bar chart for actual and budget bars, but Budget is still devided into 3 parts namely, Budget_1,Budget_2,Budget_3.

How can I show, Budget with the 3 parts comparing to Actuals in a single barchart??

attaching sample data here.

[#6]

Hi Nuthan

You have to transpose the data

please see the table in the snap shot

Regards

Padma

[#7]

Thank you Padma. It works fine.

[#8]

Hi jaro can u pl mark this answer

thanks and regards

padma