topic Re: Colors in bar chart in QlikView

Colors in bar chart

Wed, 26 Mar 2014 08:34:33 GMT

Hi,

Is it possible to use faded color for one version and normal colors for another.

e.g. In chart below I want faded colors for Past and normal for Current

Dimentions :

Year

=if(Version='2012','Past','Current')

Therapeutic Area

Expression :

sum(Revenue)

Thanks,

Prakash

Re: Colors in bar chart

jsingh71 — Wed, 26 Mar 2014 08:41:13 GMT

Go to the chart properties and put color function what you want under background color.

--Jai

Re: Colors in bar chart

linusblomberg — Wed, 26 Mar 2014 08:43:46 GMT

If you expand the expression you can very specific about the color in the "background color". You could say that if hematology 2012 then lightred(100) else lightred(). the 100 is the alpha which is what I think is what you are looking for. You can also enter the exact rgb values.

Hope this helps...

Re: Colors in bar chart

MK_QSL — Wed, 26 Mar 2014 08:44:50 GMT

Like this?

Re: Colors in bar chart

ThornOfCrowns — Wed, 26 Mar 2014 09:07:52 GMT

I didn;t know that you could set the Aplha like that - I've been using ARGB(x,x,x,x) to set it. Thanks!

Re: Colors in bar chart

linusblomberg — Wed, 26 Mar 2014 09:11:29 GMT

Glad I could help.

I usually also use ARGB since it gives complete control of the colors.

Re: Colors in bar chart

its_anandrjs — Wed, 26 Mar 2014 09:16:06 GMT

Hi,

Add a Flag field in your load like

if(Version=2012,'Past','Current') as VerFlag

and in chart in sum(Revenue) expression click + sign and in Background type a code like

=if(VerFlag='Past' and [Therapeutic Area]='Hematology',RGB(188,205,224),

if(VerFlag='Past' and [Therapeutic Area]='Oncology',RGB(253,176,168)))

Hope this helps

Thanks & Regards

Re: Colors in bar chart

its_anandrjs — Wed, 26 Mar 2014 09:25:18 GMT

Hi,

After flaging type a code below like in attached sample image

=if(Flag='Past' and [Therapeutic Area]='Hematology',RGB(188,205,224),

if(Flag='Past' and [Therapeutic Area]='Oncology',RGB(253,176,168)))

Hope this helps

Thanks & Regards

Re: Colors in bar chart

Wed, 26 Mar 2014 09:29:42 GMT

Thanks Anand