Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
hi chk dis
yes there are two expressions (updated question)
i have resolved the colour issue.
There are two expressions (updated question)
i have resolved the colour issue.
Or you can Show the both Expression value on data point using Single expression with dual function
= Dual (NumberExpression & '- ' & %Expression , NumberExpression)
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
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)