topic Re: How to line up Text on axis with bars in chart in QlikView

How to line up Text on axis with bars in chart

matthewp — Tue, 29 Mar 2016 11:13:38 GMT

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

Re: How to line up Text on axis with bars in chart

Gysbert_Wassenaar — Tue, 29 Mar 2016 11:15:51 GMT

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.

Re: How to line up Text on axis with bars in chart

jonathandienst — Tue, 29 Mar 2016 11:17:22 GMT

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.

Re: How to line up Text on axis with bars in chart

avinashelite — Tue, 29 Mar 2016 11:18:21 GMT

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

Re: How to line up Text on axis with bars in chart

Chanty4u — Tue, 29 Mar 2016 11:21:00 GMT

hi chk dis

Re: How to line up Text on axis with bars in chart

matthewp — Tue, 29 Mar 2016 11:24:20 GMT

yes there are two expressions (updated question)

i have resolved the colour issue.

Re: How to line up Text on axis with bars in chart

matthewp — Tue, 29 Mar 2016 11:24:31 GMT

There are two expressions (updated question)

i have resolved the colour issue.

Re: How to line up Text on axis with bars in chart

Kushal_Chawda — Tue, 29 Mar 2016 11:24:58 GMT

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

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

Re: How to line up Text on axis with bars in chart

Anonymous — Tue, 29 Mar 2016 11:28:55 GMT

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

Re: How to line up Text on axis with bars in chart

matthewp — Tue, 29 Mar 2016 11:29:37 GMT

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)

Re: How to line up Text on axis with bars in chart

Kushal_Chawda — Tue, 29 Mar 2016 11:32:50 GMT

Write the single Expression:

=Dual( COUNT(DISTINCT S_ID) &'-'& num((COUNT(DISTINCT S_ID)/COUNT(DISTINCT TOTAL S_ID)),'#0.00%'),

COUNT(DISTINCT S_ID))

Check the Value on Data point

Re: How to line up Text on axis with bars in chart

Anonymous — Tue, 29 Mar 2016 11:33:46 GMT

use calculated dimension with COUNT(DISTINCT S_ID)/COUNT(DISTINCT TOTAL S_ID)

and your expresion will be COUNT(DISTINCT S_ID)

Re: How to line up Text on axis with bars in chart

Gysbert_Wassenaar — Tue, 29 Mar 2016 11:35:48 GMT

If you have two expressions then the text-on-axis will be aligned with its own expression, not the other one. But perhaps you can use a combi chart and use Symbol as representation type for the second expression and set the background color of the symbol to a totally transparent color like red(0).

Re: How to line up Text on axis with bars in chart

matthewp — Tue, 29 Mar 2016 11:39:17 GMT

This is giving me both values on each point

i want % on axis and total on data point

Re: How to line up Text on axis with bars in chart

Kushal_Chawda — Tue, 29 Mar 2016 11:44:33 GMT

If you have Text on axis expression then just click on + sign and Give text color expression as Black() or red()

Re: How to line up Text on axis with bars in chart

matthewp — Tue, 29 Mar 2016 11:50:50 GMT

I mean i want it to look like this...

Re: How to line up Text on axis with bars in chart

Gysbert_Wassenaar — Tue, 29 Mar 2016 12:03:01 GMT

See attached example.

Re: How to line up Text on axis with bars in chart

matthewp — Tue, 29 Mar 2016 12:09:55 GMT

Re: How to line up Text on axis with bars in chart

Wed, 18 Jan 2017 20:15:51 GMT

I'm using the personal edition and am unable to view this file. Can the solution be explained?

Re: How to line up Text on axis with bars in chart

Gysbert_Wassenaar — Fri, 20 Jan 2017 17:49:11 GMT

Perhaps this helps: