Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different colors for different bars

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Yousuf,

You have to enable the multicolor properties into presentation tab.

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

View solution in original post

7 Replies
Not applicable
Author

Hi Yousuf,

You have to enable the multicolor properties into presentation tab.

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

View solution in original post

Not applicable
Author

thanks..it now looks so simple

jvishnuram
Partner
Partner

Hi Yousuf,

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

Not applicable
Author

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

jvishnuram
Partner
Partner

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

Not applicable
Author


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

Not applicable
Author

awesome...thanks