topic Re: Continuous X-Axis Label Problem in QlikView

Continuous X-Axis Label Problem

Fri, 24 Oct 2014 14:46:42 GMT

Hello Community,

I have a problem regarding using a continuous x-axis with YearMonth dimension values in a bar chart. It turns out that if the number of entries is below a certain number, the free places are filled with duplicate date entries:

Obviously I want that only one entry is shown. I am using the continuous dimensions to show a x-axis reference line, which is not possible without using this option.

I hope someone can help me with this issue.

Thanks in advance,

David

Re: Continuous X-Axis Label Problem

preminqlik — Fri, 24 Oct 2014 14:54:19 GMT

you are using callculated date dimension in Xaxis , so thats why it is duplicating ....use like this

Year(Date)&'-'&num(Month(Date)) as x-axis dimension

Re: Continuous X-Axis Label Problem

Fri, 24 Oct 2014 14:57:47 GMT

Hi,

thanks for your answer.

In this case I wont receive a dual date format, which is required for using the continuous label. With your formula I receive the error "no numeric values on x-axis".

Kind regards,

David

Re: Continuous X-Axis Label Problem

preminqlik — Fri, 24 Oct 2014 15:06:57 GMT

for continuous labeling go to sort and sort by following expression ascending

=only({1}Date)

Re: Continuous X-Axis Label Problem

rwunderlich — Sat, 25 Oct 2014 11:07:51 GMT

They are not really duplicate date values. They are day values in between. If you change your format to include the day you can see this. The continuous format generates it's own value labels based on dividing the range.

What you need is some way to make the font invisible on the labels you don't want. Something I can't figure out how to do on a bar chart off-hand. Maybe suppress the dimension labels and use Text on Axis for the labels? You can't get the slanted labels though.

-Rob

Re: Continuous X-Axis Label Problem

Mon, 27 Oct 2014 12:38:01 GMT

Hi Rob,

thanks for your helpful answer.

Your suggestion of using an additional expression to display the months via text on axis is useful, but unfortunately the number of entries shall not exceed a certain number in order to prevent the readability of the dimension.

Kind regards,

David