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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to implement the data on x-axis in a bar chart in diff colors?

Hi all,

I have to plot the monthname in the X-axis of the bar chart and i need to differentiate the past and future months by displaying the past months and future months on the axis in different colors.i.e i need to have 2 colors of text dislpayed on the axis.

How do i do that?

i tried using the textcolor option but not getting.

Please help.

Thanks in advance.

Labels (1)
4 Replies
Not applicable
Author

Sorry that the solution I have is not the exact one you are looking for.

You can differntiate the months by changing the colors of bars rather than changing the dimension labels. For that purpose, go to expressions, choose your expression and set a condition for the background color. As for the color of the dimension label, it seems to take the font color set in Axes-->Dimension Axis-->Font-->Color.

Not applicable
Author

Ok thanks.Can you please help in getting stacks on top of bars.Like i have to display 3 stacks actual,plan and budget over time in x-axis.In turn i need to stack each of the bars depending on the location dimension.

Not applicable
Author

Hi, I was not able to control the stacking and grouping in your example. When i tried it out that time, Qlikview 'stacked the expressions' and 'grouped the dimensions'. I don't know how to change the behaviour to the other way around.
Not applicable
Author

okay.Thank you.