How to line up Text on axis with bars in chart

[matthewp]

How can i get my text on axis values to line u with the bars in the chart?

The cart has 2 expressions with one bar hidden (the one that has the text on the axis)

can i align this with the first expression?

CURRENT

WHAT I WANT

[Gysbert_Wassenaar]

1. Make sure the Show All Bars setting on the Presentation tab of the properties window is unchecked.

2. Change the axis color setting of the dimension axis on the Axes tab

And if you need more help please post a small qlikview document that illustrates the problem.

[jonathandienst]

Looks like you might have a second expression and the on-axis numbers are centered around the two expressions.

I am not aware of any option to change the colour of the on-axis text.

[avinashelite]

Try like this

Go to >dimension/ expression > click on + mark > you will see the option for the text color and text format

change as per your requirement

[Chanty4u]

hi chk dis

[matthewp]

yes there are two expressions (updated question)

i have resolved the colour issue.

[matthewp]

There are two expressions (updated question)

i have resolved the colour issue.

[Kushal_Chawda]

Or you can Show the both Expression value on data point using Single expression with dual function

= Dual (NumberExpression & '- ' & %Expression , NumberExpression)

[Anonymous]

To change the colour of text on axes please foloow the below steps:

1)got to the chart property

2)Expression Axes:Axes-->Expression Axes-->font-->Chnage the color

3)Dimension Axes:Axes-->Expression Axes-->font-->Chnage the color

[matthewp]

Can you explain?

i want the bar and the value on data point to be COUNT(DISTINCT S_ID)

and the % on the axis to be COUNT(DISTINCT S_ID)/COUNT(DISTINCT TOTAL S_ID)