topic Re: Setting a Stacked Bar Graph Segment to Orange in QlikView

Setting a Stacked Bar Graph Segment to Orange

Tue, 06 Aug 2013 15:49:30 GMT

Hi,

I need to set one of the segments in my stacked bar chart to orange, but I do not see a function named orange(). The expression I am using to change the background color of the segments is:

if([Cost Quartile]='25th', Green(), if([Cost Quartile]='26th - 50th', Yellow(), if([Cost Quartile]='51st - 75th', blue(),if([Cost Quartile]='Above 75th', red()))))

This statement works, except that I want the section that is currently blue to be orange. How do I do that?

Thanks in advance!

Re: Setting a Stacked Bar Graph Segment to Orange

lorenwood — Tue, 06 Aug 2013 15:54:14 GMT

Hi sspangler8 Try:

if([Cost Quartile]='25th', Green(), if([Cost Quartile]='26th - 50th',Yellow(), if([Cost Quartile]='51st - 75th', RGB(255,128,0),if([Cost Quartile]='Above 75th', red()))))

Instead of Blue(), use RGB(255,128,0)

Re: Setting a Stacked Bar Graph Segment to Orange

Tue, 06 Aug 2013 17:15:50 GMT

That worked perfectly. Thanks for your help!