Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Graph with transparency

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.

VGraph.bmp

5 Replies
swuehl
MVP
MVP

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.

Not applicable
Author

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.

MayilVahanan

HI

Try like this

untitled.PNG

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

You are my God ! it works !!!

Thanks a lot! I could never find it!.

thxsssssssssssssssssssssssssssss

Not applicable
Author

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