topic Re: Stacked Chart - Custom Coloring in QlikView

Stacked Chart - Custom Coloring

Fri, 27 Jun 2014 19:16:04 GMT

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!

Re: Stacked Chart - Custom Coloring

Sat, 28 Jun 2014 04:16:50 GMT

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

Re: Stacked Chart - Custom Coloring

Sat, 28 Jun 2014 04:17:44 GMT

Please find attached sample file

Regards

Padma

Re: Stacked Chart - Custom Coloring

Sat, 28 Jun 2014 04:18:41 GMT

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

May using variables

Regards

Padma

Re: Stacked Chart - Custom Coloring

Sat, 28 Jun 2014 06:10:53 GMT

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.

Re: Stacked Chart - Custom Coloring

Sat, 28 Jun 2014 13:29:32 GMT

Hi Nuthan

You have to transpose the data

please see the table in the snap shot

Regards

Padma

Re: Stacked Chart - Custom Coloring

Sat, 28 Jun 2014 14:56:03 GMT

Thank you Padma. It works fine.

Re: Stacked Chart - Custom Coloring

Sat, 05 Jul 2014 09:11:01 GMT

Hi jaro can u pl mark this answer

thanks and regards

padma