Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change Colors of Columns in Column Chart

Hi Everyone,

I have two categories say A and B. and I want Column A to have Orange color and Column B to have green color. I need to understand How to change the default color seetings.

Thanks in Advance !!!

Regards

Anjana

21 Replies
martinpohl
Partner - Master
Partner - Master

looking for this?

Not applicable
Author

I think QlikView automatically taking color Blue and red(As present in tab colors under properties of chart) . I need to choose my own colors instead of blue and Red. How can I do the required changes. I already have expression in the charts for these two columns, Please also suggest how to add colors by expressions. Where should I add Green in my expressions.

Regards

Anjana

Not applicable
Author

Hi Anjana,

  Please find the attachment. See the dimension Background color expression.

Not applicable
Author

I already have a cyclic variable and I am wondering how to add colors where I have calculated variables . So I have some calculation there in expression page.

rsdhavle
Creator III
Creator III

Do you mean Cyclic group of expressions?

Not applicable
Author

Hi Santosh,

I am so thankful that you sent me a Qvw but then right now I am using this QlikView personal edition.

Not applicable
Author

yes

rsdhavle
Creator III
Creator III

Ok..Then at cyclic group level it will not allow you to change background color. You need to click on '+' icon beside cyclic group then you would be able to see all expressions present inside that cyclic group and you will need to define background color for each expression again.

Hope this helps

Not applicable
Author

Hi Anjana,

Please use the below expression in Cyclic Dimension background color

=if(GetCurrentField(Cyclic)='A',RGB(0,127,0),

if(GetCurrentField(Cyclic)='B',RGB(255,128,0)))

mjm
Employee
Employee

Hello Anjana,

You can change the colors of bars in a bar chart or any chart under the colors tab of the chart properties dialog. Here you can choose the desired color. It is important to choose Persistent colors so that these selections remain the same for the dimensions throughout other charts.

Please mark as useful if this answer helps.

Thanks,