topic Re: Bar Graph with transparency in QlikView

Bar Graph with transparency

Wed, 08 Aug 2012 11:52:14 GMT

Can anybody help me with bar graph with Sales to Objectives as in attached pic? Can not find answer in existing topics...

Thanks, in advance for help.

Re: Bar Graph with transparency

swuehl — Wed, 08 Aug 2012 13:45:12 GMT

To set a transparent color, use a backgorund color attribute, like

=if(B='A',LightBlue(30))

where I check my dimension B if 'A' is the current dimension value, then apply lightblue() color with an alpha of 30.

To achieve the overlapping of bars, you can for example use the 3D bar style.

See attached.

Re: Bar Graph with transparency

Thu, 29 Nov 2012 18:34:52 GMT

hello swuehl

Please could you attach a screenshot where you use the formula =if(B='A',LightBlue(30)) in your graphic?

I got crazy looking for it and I can't find it. What's more i pasted your graphic in my projecte and instaly becomes opaque ...

What i really like is the transparent column in front

thanks in advanced.

Re: Bar Graph with transparency

MayilVahanan — Thu, 29 Nov 2012 18:40:16 GMT

Try like this

Re: Bar Graph with transparency

Thu, 29 Nov 2012 19:56:55 GMT

You are my God ! it works !!!

Thanks a lot! I could never find it!.

thxsssssssssssssssssssssssssssss

Re: Bar Graph with transparency

Mon, 31 Dec 2012 16:56:26 GMT

Vladislav,

Could it be posible that you attach a copy of your graph please. I tried a lot to make a similar one but it was imposible. I can't get diferent expresions overlaped thet way you did.

Thanks in advanced