topic Re: Different colors for different bars in QlikView

Different colors for different bars

Wed, 01 Jan 2014 05:28:55 GMT

Hi Experts,

IN my attached qvd, i have 8 products. I want the first 3 products to be in red (bar color), the next 3 in yellow and the last 2 in blue. How this can be achieved.

Thanks

Re: Different colors for different bars

Wed, 01 Jan 2014 06:09:16 GMT

Hi Yousuf,

You have to enable the multicolor properties into presentation tab.

accordingly you can change your color PFA. for your Reference.

Re: Different colors for different bars

Wed, 01 Jan 2014 06:15:06 GMT

thanks..it now looks so simple

Re: Re: Different colors for different bars

jvishnuram — Wed, 01 Jan 2014 06:18:07 GMT

Hi Yousuf,

You can also use the background color in the expression, find the attachment.

Re: Different colors for different bars

Wed, 01 Jan 2014 06:46:31 GMT

Hi Vishnu,

Can you paste the expression here since i am working from home and currently don't have access to the licensed version.

Thanks

Re: Re: Different colors for different bars

jvishnuram — Wed, 01 Jan 2014 06:53:20 GMT

Hi Yousuf,

This is the expression,

=if(Product='Accessories' or Product='Laptop' or Product='Monitor'

,Green(),

if(Product='Notebook' or Product='Printer' or Product='PS3',Red(),

if(Product='Scanner' or Product='Server',Yellow())))

and you need to be paste here,find the attachment

Re: Different colors for different bars

Wed, 01 Jan 2014 07:28:12 GMT

Hi,

you can use pick function .

properties->expression->expand ->+->Backgroundcolor->Defination

=pick(match(Product,'Laptop','Desktop','Keyboard',red(),blue(),green())

.i hope it will give better performance.

ihopw it will be helpful to you.

PFA,

regards

Mahesh

Re: Different colors for different bars

Wed, 01 Jan 2014 07:33:40 GMT

awesome...thanks